-
1. Re: Creating a table of cumulative monthly growth from daily growth
Patrick A Van Der HydeDec 21, 2015 1:31 PM (in response to Yan Wu)
Hello Yan Wu,
I think you just want the percent difference by month. Is that right?
(ZN(SUM([Growth])) - LOOKUP(ZN(SUM([Growth])), -1)) / ABS(LOOKUP(ZN(SUM([Growth])), -1))
This is a buit in Table Calculation in Tableau that you can get by right clicking on the Growth field (when placed on the view) and selecting Quick Table Calculation > Percent Difference from the drop down field.
See attched sheet 3.
Thank you for posting the workbook as well.
Does this provide the output desired?
Patrick
-
Sample Growth pv.twbx 25.5 KB
-
-
2. Re: Creating a table of cumulative monthly growth from daily growth
Shawn Wallwork Dec 21, 2015 2:01 PM (in response to Patrick A Van Der Hyde)Yes!
Thank you for posting the workbook as well.
We all thank you (and all who attach workbooks), as they make our 'helper' jobs so much easier. I'd also like to add, we're sorry it took us so long to get to your question. Please don't bail on our forums, we will do better for you on your next question!
--Shawn
-
3. Re: Creating a table of cumulative monthly growth from daily growth
sushma.koyi May 29, 2016 2:10 AM (in response to Yan Wu)How did you derive growth rate from Super store data source ??? I also have similar problem, which needs to be calculated Month-over-month Growth Rate for Office Supplies ???
Thanks,
Sushma