Hi Tableau enthusiasts,
My data has Consumer Revenue numbers and I am trying to calculated the percentage growth of the rolling 12 months.
Eg:
Month & Year
Consumer Revenue
June 20172000July 20171500August 20172000September 20172000xxxxxxxxxxxxxxxxJuly 201810000August 201820000
To derive the 1 year consumer revenue (rolling months), the formula i used is: WINDOW_SUM(SUM([Consumer Revenue]),-11,0)
Result:
Month & Year
Consumer Revenue
1 Yr Consumer Revenue
June 201720002000July 201715003500August 201720005500September 201720007500xxxxxxxxxxxxxxxxxxxxxxxxxJuly 201810000150000August 201820000155000
PS: 'xxxx' reflects hidden data from October 2017 to June 2018
From the 1 Yr Consumer Revenue data, I want to find the percentage difference month on month of the 1 Yr Consumer revenue. I generally use quick calculations to find the percentage difference, but since this is a derived column, that option isn't there.
Can someone help me how to go about with it?
Thank you.
% differnce internally is (ZN(SUM([Profit])) - LOOKUP(ZN(SUM([Profit])), -1)) / ABS(LOOKUP(ZN(SUM([Profit])), -1))
Thanks,
Ritesh
