Excel type Pivot Table with collapsible groups

[lipster26]

Hi,

I'm trying to recreate a pivot table for the Alteryx workflow output. I've tried Cross tab and summarize but can't seem to replicate it in Alteryx. 

I want to group by Unit, Temp Diff Code and Account. Temp Diff Code and Account should have subtotals but be expandable and collapsible.

Thanks for any help.

This is the data coming from Alteryx:

This is what i want it to be like in Excel:

[atcodedog05]

Hi @lipster26 

This output is not possible to be outputted by alteryx.

This functionality is specific to Excel.

[markcurry · Accepted solution]

Hi @lipster26 

I've mocked up a workflow that gives you 3 different examples of an output that is close the Excel output.  So hopefully that will help you.