We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

alteryx Community

# General Discussions

Discuss any topics that are not product-specific here.
SOLVED

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

6 - Meteoroid

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

15 REPLIES 15
13 - Pulsar

Many thanks

Shanker V

13 - Pulsar

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

12 - Quasar

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

13 - Pulsar

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

6 - Meteoroid

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

13 - Pulsar

Got it, rearranging the workflow as per your need.

13 - Pulsar

Input was:

Many thanks

Shanker V

13 - Pulsar

One more way also.

Step 1: Input

Step 2:

!Contains([Particulars],"Closing")

Step 3:

Many thanks

Shanker V

13 - Pulsar

Step 4: Summarize tool

Step 5:

Step 6:

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

Many thanks

Shanker V

Labels