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 |
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!
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
Step 1: Input
Step 2: Summarize tool
Step 3:
Step 4: Union tool
Many thanks
Shanker V
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