Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to find Subtotal and Grand total

Pandey19
6 - Meteoroid

Hi,

I've my data like below where i need to find Subtotal for each Name column and then finally grand total of all.

Ex- US total is having subtotal of Name=US for each VAR and ABS VAR column. Like wise we need to find EMEA total and APAC total.

One more thing is that some records are empty under Name. Like in APAC we have 4 ID's but APAC coming only once in column Name. Like a normal excel pivot table.

How to achieve this in alteryx?

 

I've taken only 3 values in Name column

NameIDVARABS VAR
US 213213
US total 213213
APAC12310093535
 345313233
 567351313
 7653523
APAC Total 13925104
EMEA 122539
 897313121
 1234323
EMEA total 778683
Grand total 23836000
8 REPLIES 8
Chris86
8 - Asteroid

Have you tried the method employed in this post? Pivot Table Display as Grand Total

Christina_Hurrell
9 - Comet

Here's my solution.  The names are coming out in alphabetical order, there will be a little more work if you need to maintain the incoming order.

Christina_Hurrell_0-1631712241759.png

 

MatthewBr
Alteryx
Alteryx

@Chris86  - What's the best way to be able to place the subtotals where you want in the list.  (see screen shot)

 

MatthewBr_0-1631713202072.png

 

binay2448
11 - Bolide

Displayed two ways may be it can help..

Pandey19
6 - Meteoroid

Exactly. how to place the total in appropriate position and keep ID column also?

Like below

NameIDVARABS VAR
US 213213
US total 213213
APAC12310093535
 345313233
 567351313
 7653523
APAC Total 13925104
EMEA 122539
 897313121
 1234323
EMEA total 778683
Grand total 23836000
Christina_Hurrell
9 - Comet

@Pandey19 This is the output from my solution above, with subtotals placed after groups and grand total at the end.  Currently in alphabetical order of names but that could be fixed in a few extra steps.

Christina_Hurrell_0-1631715150560.png

 

binay2448
11 - Bolide

Is this output is not ok for you?

binay2448_0-1631715552576.png

 

binay2448
11 - Bolide

Hi @Pandey19 ,

 

If you are ok the solution then please mark it as a solution.

Labels