Subtotal and Grand Total

Question

Input after summarization

accountnameaccounttype<3  months3-12 months1-3 yearsGrandtotalcurrentL1100200300600

output

accountnameaccounttype<3  months3-12 months1-3 yearsGrandtotalcurrentL1100200300600subtotal 100200300600Grandtotal 100200300600

binu_acs · Answer

@VaishnaviGinni One way of doing this with the macro

Grand Total_1121.yxzp

ShankerV · Answer

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

ShankerV · Answer

Hi @VaishnaviGinni

Step 1: Input

Step 2: Summarize tool

Step 3:

Step 4: Union tool

Many thanks

Shanker V