asked on June 12, 2019
Hello, one of our clients is interested in having a flat-mode style excel export with the subtotals that are present in classic mode. That is, they would like all of the dimension rows populated from the classic mode export so it resembles flat mode, but retains the subtotals present in classic. Currently the higher dimensions will have leave blanks in the export, as that is the appearance of the classic mode currently.
Is there some way to toggle the population of the higher dimensions in classic so that they populate and subsequently get pushed to the excel export? Any sort of tweaking to either flat or classic mode would be welcome.
⋅ June 13, 2019
Hello, Daniel,
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
⋅ June 13, 2019
Yes, this would be the output we're looking for. Thank you!
