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!
-Chris
⋅ 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,
Vera
