3 Replies Latest reply on May 29, 2016 2:10 AM by sushma.koyi

# Creating a table of cumulative monthly growth from daily growth

Hello,

I have a sample data of daily growth rates from sales from 3 different stores (unfortunately these are not real growth rates of these stores).

I can create a cumulative growth chart very simply using:

(1+sum([Growth]))*(1+PREVIOUS_VALUE(1))-1

I would like to create a table that shows the month over month growth rates.  Ideally, it would be 3 sections for the 3 stores, Year going down the rows and months across the columns.

I tried messing with it, but I cannot get the calculations to work.

Does anyone have any ideas on how to do this?

• ###### 1. Re: Creating a table of cumulative monthly growth from daily growth

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

• ###### 2. Re: Creating a table of cumulative monthly growth from daily growth

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

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