How to do % change for Grand Total

[anamik72]

Hello, 

Customer	2019 value	2020 value
Cust A	80	100
Cust B	100	110

Customer	Growth rate
Cust A	25%
Cust B	10%

I am able to calculate this growth rate. But I don't know how to calculate growth rate of grand total of Cust A and Cust B. Can you help? Thanks

[ponraj]

Here is my solution. 

[anamik72]

Thank you for your help. But I am trying to understand how to do % on grand total. In this case, total volume is growing from 180 to 210. That's 16.7% increase. How do I show/calculate grand total growth also? Thanks

[RobertOdera · Accepted solution]

Hi, @anamik72 

Please see the attached.

Please accept as a solution if it meets your requirements.

[anamik72]

I got an error message when trying to open Alteryx package since I have older version (2019.2). Is there any way you can send the workflow without putting in a package? Thanks

[anamik72]

It worked. Thank you so much.

[RobertOdera]

Hi, @anamik72 

Sorry, I missed yesterday's message, but I'm glad it all worked out.

Thank you for the question, and please continue to ping the community if you need anything else!