Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

In Classic view is there a way to allow cascading of grouped values?

Christopher Phillips asked on June 21, 2019

In Excel when pivoting users are able to have cascading values. Please see attached images of the same pivot view one with cascading and one without. Our users are using the Flexmonster pivot as a source and need the repeated values so that their SUMIFS() and INDEX functions can pull data from it correctly. 
We are requesting that this feature be added to Flexmonster if it is at all possible.
Thanks in advance!

1 answer

Vera Didenko Flexmonster June 21, 2019

Hello, Chris,
Thank you for writing to us.
We would like to confirm that the desired output can be achieved by the help of the customizeCell() API call
Here is a JSFiddle example illustrating this approach.
Please let us know if this works fine for you.
Best Regards,

Please login or Register to Submit Answer