9 Replies Latest reply on Mar 10, 2016 1:14 AM by Aakash Udasi

month on month growth

Hello wonderful community,

I have products in Rows AND months & two measures in column.

I want to compute month on month growth of these two measures with their RESPECTIVE previous months figures...If the increase/decrease in growth is beyong 5 percentage then i want to highlight it in some way...

kindly advise

Thanks in advance

Regards

Aakash

• 1. Re: month on month growth

Hi Aaksah ,

Please post a sample workbook.

• 2. Re: month on month growth

Hi Akash,

Here is the formula for MOM% change : (SUM([Measure]) - LOOKUP(SUM([Measure]), -1)) / (LOOKUP(SUM([Measure]), -1))

• 3. Re: month on month growth

Hi

I am not getting the desired output... I am not able to understanding computed filed "Calculation1". I used the formula which was provided by you.

Kindly assist. Attaching test file for your reference

Regards

Aakash

• 4. Re: month on month growth

Hi Aakash,

I used parameter and did it .check the MOM.

• 5. Re: month on month growth

Hi Tharashasank,

Again this is not the one i am looking for.

Can you do something to the workbook i had sent you. I want to compute MoM on both measures.

Thanks

Aakash

• 6. Re: month on month growth

I edited the calculated field a little bit and is it what you are looking for?

Essentially you want to use the table calculation across to calculate the monthly difference.

1 of 1 people found this helpful
• 7. Re: month on month growth

Hello Jing Qing,

I am not able to open your attachment as it has been created in newer version. I am using version 9.1

Could you please save it as in older version. Alternatively you can share the logic & edited formula with me.

Thanks

Regards

Aakash

• 8. Re: month on month growth

Hi Akash,

Check the workbook.

I have suggested you the formula to use:MOM% change : (SUM([Measure]) - LOOKUP(SUM([Measure]), -1)) / (LOOKUP(SUM([Measure]), -1))

In your workbook you have used with only total value like this:(SUM([Total Value]) - LOOKUP(SUM([Total Value]), -1)) / (LOOKUP(SUM([Total Value]), -1))

But in the attached workbook we have created two calculated fileds: one for Total value and another for Discount amount and we named them as MoM Total %  and MoM Discounted %

MoM Total % :(SUM([Total Value]) - LOOKUP(SUM([Total Value]), -1)) / (LOOKUP(SUM([Total Value]), -1))

MoM Discounted %:(SUM([Discount Amount]) - LOOKUP(SUM([Discount Amount]), -1)) / (LOOKUP(SUM([Discount Amount]), -1))

This is what it is done in the workbook.

I have given the work book in the lower version check it.

• 9. Re: month on month growth

Many Thanks both of you.

This is what i was looking for