How to get Total(Index wise),then Sub total and Grandtotal

[VaishnaviGinni]

Input

Product	Index	amount	grandtotal
spoon	401	1,388,455.97	1,388,455.97
Glass	405	123456.77	123456.77

Output

Product	Index	amount	grandtotal
spoon	401	1,388,455.97	1,388,455.97
	401 Total	1,388,455.97	1,388,455.97
Glass	405	123456.77	123456.77
	405 Total	123456.77	123456.77
Product Total		1511912.74	1511912.74
Grand Total		1511912.74	1511912.74

[ShankerV]

Hi @VaishnaviGinni 

Yes it is possible. Do you need to apply for huge dataset also?

Many thanks

Shanker V

[ShankerV]

Hi @VaishnaviGinni 

Please find the expected output.

Many thanks

Shanker V

[ShankerV]

@VaishnaviGinni 

Tweaked the workflow to get the better output.

Many thanks

Shanker V

[ShankerV]

Hi @VaishnaviGinni 

Step 1:

Step 2:

Step 3:

[ShankerV]

Step 4:

Step 5:

Step 6:

[ShankerV]

Step 7:

Step 8:

Step 9:

[ShankerV · Accepted solution]

Step 10:

Step 11: + Output

[ShankerV · Accepted solution]

Hi @VaishnaviGinni 

If it resolves your issue, Feel free to mark helpful answers as a solution so that future users with the same issue can find them easier!

Many thanks

Shanker V

[VaishnaviGinni]

Many thanks for your help. It is working and output is coming as expected.