How to sum a column and Add total at the bottom of the column?

[SanaUlBari]

Hi All

I am trying to sum and add the sum total at the bottom of the column. For Sum i am using summarize function but how to add that sum as 'closing' balance in the below table?

Thanks

Sana

[ShankerV · Accepted solution]

Hi @SanaUlBari 

Please find the expected output.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @SanaUlBari 

Step 1: Input

Step 2:

Step 3:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[JamesCharnley · Accepted solution]

Hi @SanaUlBari 

I like to use a CReW macro for this called Add Totals that looks like this:

You can find more about CReW macros and download them here: http://www.chaosreignswithin.com/p/macros.html

[ShankerV · Accepted solution]

Hi @SanaUlBari 

Step 4: Summarize tool

Step 5:

if Contains([Particulars], "Closing")
then "Sum Closing"
else [Particulars]
endif

Step 6:

Output:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[SanaUlBari · Accepted solution]

Sorry for the confusion Shanker, i actually meant how to add individual totals at the bottom of each column i.e Sum of Jan column as 1,270 (by adding row 1-8) and for Feb as 1,134 (by adding row 1-8). I am using summarize table which gives me total of the column but i am not sure how to make this total part of the original column. Currently closing balance as shown in above table is as per manual calculation, i want to automise it through alteryx

Thanks

Sana

[ShankerV · Accepted solution]

Hi @SanaUlBari 

Got it, rearranging the workflow as per your need.

[ShankerV · Accepted solution]

Hi @SanaUlBari 

Please find the revised output.

Input was:

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @SanaUlBari 

One more way also.

Step 1: Input

Step 2: 

!Contains([Particulars],"Closing")

Step 3: 

Many thanks

Shanker V

[ShankerV]

Hi @SanaUlBari 

Step 4: Summarize tool

Step 5:

Step 6:

Replace([_CurrentField_],"_","-")

Many thanks

Shanker V