8 Replies Latest reply on May 31, 2016 2:57 AM by sushma.koyi

# what is the month over month growth rate for office supplies ??

How did you derive growth rate from Super store  data source ??? I have to calculate Month-over-month Growth Rate for Office Supplies ???

Thanks,

Sushma

• ###### 1. Re: what is the month over month growth rate for office supplies ??

Follow the link. Just put Category in filters shelf and select only Office Supplies

month over month growth %s next to monthly revenue

• ###### 2. Re: what is the month over month growth rate for office supplies ??

I am just taking Profit as parameter. In that question, they didn't mention to take whether the sales or profit or some other value like profit ratio..Do you think that is that right to take profit ??? Here is how it looks if i take profit as shown below.

Thanks,

Sushma

• ###### 3. Re: what is the month over month growth rate for office supplies ??

Yeah Its correct. You can put your any measure in that formula.

Feel free to ask If you've any query.

Mahfooj

• ###### 4. Re: what is the month over month growth rate for office supplies ??

Hi,

I had similar question below..What is the sales amount of texas in mom growth calculation ???

Taking percentage difference yields 3 values based on sorting differently.

Thanks,

Sushma

• ###### 5. Re: what is the month over month growth rate for office supplies ??

Please make such practice from going forward.

• ###### 6. Re: what is the month over month growth rate for office supplies ??

You mean to say that 563.86% is the right answer for that first question ???....

Thanks,

Sushma

• ###### 7. Re: what is the month over month growth rate for office supplies ??

See this is for your MoM. You haven't put any month field so that you can get exact output. The calculation is correct.

I've given you both result from excel as well tableau. Drag fields as per the screen shot. I've put filter on year 2014 and showing month year data for Categories.

Let me know If you've any query.

Mahfooj

• ###### 8. Re: what is the month over month growth rate for office supplies ??

Thanks. I have got the similar answer.