🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
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 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