Advanced Export to excel across multiple worksheets

[#1]

Hi community,

I'm trying to get some advanced functionality out of my excel export.  I have a Pivot chart in the attached sample.  When I export the data to excel, it will export to one worksheet in excel.  I'm trying to get it so that when I export it, the grouped field shows up on it's on worksheet.  See the attached excel example.  Does anybody know how to do this?  further to this, it would be amazing if someone knew how to name the worksheets after each channel.  For this example, rather than having each worksheet titled, sheet1, sheet2, sheet3 etc..  they would be called CONVENIENCE/GAS, DRUG STORE, LIQUOR STORE etc....

thanks!

[Gysbert_Wassenaar · Accepted solution]

See here