I have data structure organized in three levels (FIRST -> SECOND -> THIRD). Under one value of the FIRST group I don’t have values for SECOND and THIRD and I can drill down twice with (blank) values. Can I prevent drill down or hide rows for some dynamic data values, but still see their values in FIRST group total
Thank you for your interest in Flexmonster Pivot.
Our component does not support preventing drill down for some dynamic data values. However, you can replace
(blank) values with your custom ones by setting the localization for this message. Please have a look at the following example: http://jsfiddle.net/flexmonster/mr0Lwkab/58/. In this sample, USA does not have State and City, but the values are not
(blank) . I hope this approach can help you. If you need a more advanced approach for replacing
(blank) message, you can use customizeCell function.
Please let me know if you have any other questions.
Thank you Tanya for your answer.
I have already implemented customizecell function function and added in html for style “display: none” for those row cells. But dynamic drill down prevent would be more elegant way to solve my issue.
Is there possibility to remove expand arrow for the first group element, by removing/adding some class value to html object ?
Thanks for the quick update.
Currently, it is not possible to remove expand arrow for the first group element, by removing/adding some class value to HTML object.
Should you have any other questions – feel free to ask.
The version of the Flexmonster has changed
Can I prevent drill down or hide rows for (blank) values now?
Thank you for writing to us.
Our recommendations for such cases remain the same: replace the
(blank) values with custom ones either by setting the localization as in the example above or by using the customizeCell function. The latter approach provides more flexibility.
Please let me know in case of any other questions.