How to find Subtotal and Grand total

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

Name	ID	VAR	ABS VAR
US		213	213
US total		213	213
APAC	123	1009	3535
	345	313	233
	567	35	1313
	765	35	23
APAC Total		1392	5104
EMEA		122	539
	897	313	121
	12	343	23
EMEA total		778	683
Grand total		2383	6000

Workflow

Accepted answers

binay2448

Displayed two ways may be it can help..

How to find Subtotal and Grand total.yxmd

All comments

Link86

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

Christina_H

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.

Subtotals.yxmd

MatthewBr

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

binay2448

Displayed two ways may be it can help..

How to find Subtotal and Grand total.yxmd

Pandey19

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

Like below

Name	ID	VAR	ABS VAR
US		213	213
US total		213	213
APAC	123	1009	3535
	345	313	233
	567	35	1313
	765	35	23
APAC Total		1392	5104
EMEA		122	539
	897	313	121
	12	343	23
EMEA total		778	683
Grand total		2383	6000

Christina_H

@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.

binay2448

Is this output is not ok for you?

binay2448

Hi @Pandey19 ,

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15873

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703