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]

@VaishnaviGinni 

Welcome, happy to help!!!

Many thanks

Shanker V

[VaishnaviGinni]

Hi,

I am getting the output of subtotal and grandtotal.

But index wise total is not coming.

Can you help me on the same.

My output is coming like this.

Output

Output

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

[ShankerV]

Hi @VaishnaviGinni 

Can you please attach your workflow.

So that can check what went wrong in your workflow and resolve it for you.

Many thanks

Shanker V

[VaishnaviGinni]

It is solved now many thanks for your help.

Regards

Reeta