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

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

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