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:

markcurry

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.  

Pivot Table Example.yxmd