Adding total amount

[Jenny814]

Hi Friends,

Could you please help me with the task below? Adding a "total amount" , thank you!!

[alexnajm]

Can we have your workflow with the data included? The best way is to Export Workflow under Options

[Jenny814]

Please see the excel file uploaded. Thank you!!!!!

[alexnajm]

Great thank you - that helps us confirm the data!

I am away from my computer but I would bring down a Summarize tool, making sure to Sum the fields that you want totaled. You can also remove the prefixes in that tool to make sure the same name remains BECAUSE then afterwards you’d use a Union tool to stack the original data and the summarized data. They should stack automatically as long as the column names are the same. 

here’s a text version of what I’d do - try it out on your side!

Input >————————> Union

        ‘>——Summarize—^

[Qiu · Accepted solution]

@Jenny814 
There is a function " Total Row" in the Cross Tab tool  and we can utilize it for achieve what you need.

[Jenny814]

Thank you so much, Qiu!