Subtotal and Grand Total

[VaishnaviGinni]

Input after summarization

accountname	accounttype	<3 months	3-12 months	1-3 years	Grandtotal
current	L1	100	200	300	600

output 

accountname	accounttype	<3 months	3-12 months	1-3 years	Grandtotal
current	L1	100	200	300	600
subtotal		100	200	300	600
Grandtotal		100	200	300	600

[Felipe_Ribeir0]

Hi @VaishnaviGinni 

One way of doing this

[CarliE]

@VaishnaviGinni 

Attached is a workflow that I built -- this takes in account if there are multiple account types / multiple subtotals.

Please be sure to mark this as a solution if this solved your problem to help other community members out!

[ShankerV]

hi @VaishnaviGinni 

Please be informed that, the solution is proposed in such way where it will work for huge data sets too.

Input: 

Output:

Many thanks

Shanker V

[ShankerV]

Hi @VaishnaviGinni 

Step 1: Input

Step 2: Summarize tool

Step 3:

Step 4: Union tool

Many thanks

Shanker V

[ShankerV]

Hi @VaishnaviGinni 

Step 5: 

Step 6:

if (mod([RecordID],3)=0)
then "Grandtotal"
elseif(mod([RecordID],2)=0)
then "Subtotal"
else [accountname]

endif

Output:

Many thanks

Shanker V

[binuacs]

@VaishnaviGinni One way of doing this with the macro