Adding Subtotal to customized emails using Alteryx email tool

[vivaisun11]

Hello.
I am trying to add a subtotal row (different subtotal for each email) when sending a dataset via Alteryx email to a user group.
Attached is my current and desired email output format.
Any suggestions on how I can go about adding subtotals for several groups? I tried using the summary tool, and joining back to the dataset, but I have some mis-sorting.

[Raj]

@vivaisun11 
you can use summarize tool to find the grand total and then append this to your original data before creating a table

hope this helps

[Raj]

@vivaisun11 
find the workflow attached for reference

mark done if solved.

[vivaisun11]

I need a subtotal for each unique customer, which is a sub-category. Not the grand total.

[vivaisun11 · Accepted solution]

Found a solution in the below link. Credit goes to @Kenda 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Subtotals/m-p/1282473#M320280