prevent expanding depending from some value

Answered

Hello,
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,
Laslo

3 answers

Public
Tanya Gryshko Flexmonster October 27, 2017

Hello, Laslo,
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.
Regards,
Tanya

Public
Laslo Horvat October 27, 2017

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 ?
Thank you,
Laslo

Public
Tanya Gryshko Flexmonster October 27, 2017

Laslo,
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.
Regards,
Tanya

Please login or Register to Submit Answer