Add total

[Thiviya]

Hi,

How do I  add total at the bottom of the table for each column i.e AM, AP , Con etc 

This is under the "Sum" workflow.

[Peachyco]

I would use the Summarize Tool to sum the necessary columns, then use the Union Tool to insert the row of totals/sums in the original table, like so:

This is how my sample data started:

And this is how it ended up:

 

[Amol_Telore]

Hey @Thiviya 

Please check attached workflow. Using Cross Tab we can add Total Row Line in the data.

[Thiviya]

Hi,

Thanks for the below. That's what I want, but how did you put together in the workflow. Are you able to sent the workflow formula and details. 

[Thiviya]

Hi,

I cannot see all the information on the workflow.. 

Are you able to resnd it . Thanks

[Thiviya]

HI, 

I have got the total in each columns. However how do I add the word " Grand Total" in the row