Render Table by Group to Individual Excel Sheets NOT Files

[hellyars]

Render issue.

I have to render 374 Excel tables.  They currently render to a single sheet.  They are grouped by the field [H1] which is essentially the title for each table.   Grouping by H1 create the individual tables.   Now I want to group the tables by the field [H0] (=Market) and render each Market Group on its own sheet -- not its own workbook.   There does not seem to be a simple check this to export by sheet (like there is in the Output Tool).  I swear the reporting tools are so frustrating. 

[christine_assaad]

Hi @hellyars 

You could get multiple tabs on the same file by configuring the layout to be based on "Vertical with section Breaks". See below.

I am also attaching a sample workflow that could help. Cheers!

[afv2688]

Hello @hellyars ,

I've set up a little example here.

Regards