How to create subtotal "Net Income" from raw TB data

[shungui]

Hi All,

I'm really struggling here. How can I create a sub-total (almost like a PIVOT Table view) of raw TB data. I've filtered my trial balance to isolate only profit and loss accounts, but I'm trying to figure out how I can summarize each entity's net income (noted in the "CO #" column). 

In excel, I could easily do this via a PIVOT table of the Co # field and the "Account Category" field.

Any help is greatly appreciated.

Thank you!

[binuacs]

@shungui the below weekly challenge might be helpful for this scenario

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-292-It-s-about-Pivoting-Prepping-and-Rep...

[shungui]

Hi I'm in a bit of a time-crunch and don't have time for that.

[amruthas2]

Hi @shungui 
You can use summarize function - group by the field you require and sum up the value, also if in the Account Category you have more than P&L which you dont need, you can use filter option to exclue that.

Please let me know if you need any further change on the below solution, or if this was able to solve your problem