Input ProductIndexamountgrandtotalspoon4011,388,455.97 1,388,455.97 Glass405123456.77123456.77 Output ProductIndexamountgrandtotalspoon4011,388,455.97 1,388,455.97 401 Total1,388,455.97 1,388,455.97 Glass405123456.77123456.77 405 Total123456.77123456.77Product Total 1511912.741511912.74Grand Total 1511912.741511912.74

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

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

AMP Engine

AMP-Engine

Accepted answers

ShankerV

Step 10:

Step 11: + Output

ShankerV

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

All comments

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

Step 10:

Step 11: + Output

ShankerV

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.

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703