Create row to sum the column

[hegdepavithra10]

Hi,

I want to sum each of columns as seen below, but i want them to summed beneath the columns.

note: the rows in which the data is present does not have to be restricted to 4 rows only

@atcodedog05 could you suggest.

Is there a way that this could be done without using a macro.

[T_Willins]

Hi @hegdepavithra10,

Here is a great Alteryx article on how to use Transpose and Cross Tab tools to add a summary row:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Transpose/ta-p/89741

[WernerE]

Hi @atcodedog05,

Here is a quick example of how to get the desired result using the transpose and crosstab tools. 

Hope it helps. Feel free to ask if you have any questions. 

[echuong1]

Any easy way to add totals is with the Add Totals Crew Macro.

You can download the tools here:

http://www.chaosreignswithin.com/p/macros.html 

[Qiu]

@hegdepavithra10 

How about using a Cross Tab Tool

[hegdepavithra10]

Is there a way that only selected columns can be summed ?

[Qiu]

@hegdepavithra10 
Lets use a filter tool

[hegdepavithra10]

@Qiu  which fields must be selected under transpose ?

[atcodedog05]

Hi @hegdepavithra10 

Here is a workflow for the task. My take on this

Output:

Workflow:

Add columns in summarize for whichever you need total

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[grazitti_sapna · Accepted solution]

Hi @hegdepavithra10 ,

Try this if it works for you. Using Summarize tool you can select the columns particularly you want the total for.

Under transpose you need to select the column fields in data column part and record id in key column.

In case you want to solve this using transpose and crosstab tool for particular column(s) try this.

I hope it helps. Kindly mark this post as solution if it solves your purpose.

Thanks.