Hello, Customer2019 value2020 valueCust A80100Cust B100110 CustomerGrowth rateCust A25%Cust B10% 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

How to do % change for Grand Total

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

Expression

Accepted answers

RobertOdera

Hi, @anamik72

Please see the attached.

Please accept as a solution if it meets your requirements.

For_anamik72.yxzp

All comments

ponraj

Here is my solution.

How to do percentage change for Grand Total.PNG

How to do percentagechange for Grand Total.yxmd

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

Hi, @anamik72

Please see the attached.

Please accept as a solution if it meets your requirements.

For_anamik72.yxzp

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703