Flat-mode style export in Classic mode

Daniel Rutledge 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.

2 answers

Public
Vera Didenko Flexmonster 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

Public
Daniel Rutledge June 13, 2019

Yes, this would be the output we’re looking for. Thank you!

Please login or Register to Submit Answer