Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Adding Total Row to Table

Bharkavi
5 - Atom

Hello everyone,

 

I am trying to add a total row to my dataset as seen below, without using a macro. I would lie to sum the values for each month and all the values below. I saw that you can use transpose and cross tab tool, however the cross tab tool tries to sum my first few columns (region, role, name etc.) although they are string values. I hope that is clear and any help is appreciated, thank you!

 

 

Input:

RegionRoleNameCityCommentsJanFebMarAprMay
AmericaManagerAnneBostonnull55005600570058005900
APACAnalystJohnMalaysianull45004600470048004900

 

Output:

RegionRoleNameCityCommentsJanFebMarAprMay
AmericaManagerAnneBostonnull55005600570058005900
APACAnalystJohnMalaysianull45004600470048004900
    Total10,00010,20010,40010,60010,800
4 REPLIES 4
KGT
12 - Quasar

The4 easiest way to do this is to use a summarise and then union it on.

 

Use the summarise to create the totals.

Formula to create your field "Comments" that will have the text "Total"

Union with the option at the bottom to select specific order.

 

The tool at the top in this screenshot is the CReW Macro to do exactly this operation.

AlteryxGui_uLRPXLpl0u.png

Qiu
21 - Polaris
21 - Polaris

@Bharkavi 
I made some changes to the flow of @KGT  to be more dynamic.

0107-Bharkavi.png

SPetrie
13 - Pulsar

This is a small variation on the flow @Qiu made. The crosstab tool has an option for adding a total row, so I used that instead of the summarize tool.

example pic.PNG

Qiu
21 - Polaris
21 - Polaris

@SPetrie 
You are right.👍 Forget about that feature. 

Labels
Top Solution Authors