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

[TimN]

Hi,

Something like this?

[PanPP · Accepted solution]

Hi @knnwndlm 

I have provided a sample WF that matches your output.

[knnwndlm]

Thank you so much @PanPP!!

[TimN]

Hi,

@PanPP @knnwndlm ,

The Data Types are incorrect in the Select Tool 75.  You need to update that to Fixed Decimal.

Tim

[TimN]

It's also affected by the "-" coming in from the data to represent null or zero.  I think you need to convert that to a null or zero and then convert the columns to fixed decimal.