Data Summary

knnwndlm

Hi SME,

In the attached file, I have the Source tab.  How do I get to the Desired Output tab?  In essence, I'm trying to format the report in a way that's like a pivot table in Excel.  I've attempted to create a workflow to do so but it got way complicated and I'm not able to create the subtotal under each category.  There's got to be a more sensible way to do this.  Appreciate your help.

Thanks,

Konn

Pivot Example.xlsx

PanPP

Hi @knnwndlm 

I have provided a sample WF that matches your output.

Sample WF - Pivot.yxmd