
1. Re: month on month growth
Tharashasank Davuluru Mar 9, 2016 3:20 AM (in response to Aakash Udasi)Hi Aaksah ,
Please post a sample workbook.

2. Re: month on month growth
Tharashasank Davuluru Mar 9, 2016 3:25 AM (in response to Aakash Udasi)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
Aakash Udasi Mar 9, 2016 5:01 AM (in response to Tharashasank Davuluru)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

Test.twbx 1,006.6 KB


4. Re: month on month growth
Tharashasank Davuluru Mar 9, 2016 5:27 AM (in response to Aakash Udasi)Hi Aakash,
I used parameter and did it .check the MOM.

Test (2).twbx 996.2 KB


5. Re: month on month growth
Aakash Udasi Mar 9, 2016 6:27 AM (in response to Tharashasank Davuluru)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
Jing Qing Mar 9, 2016 3:37 PM (in response to Aakash Udasi)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.

Test_1.twbx 989.4 KB


7. Re: month on month growth
Aakash Udasi Mar 9, 2016 11:21 PM (in response to Jing Qing)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
Tharashasank Davuluru Mar 9, 2016 11:57 PM (in response to Aakash Udasi)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.

Test_1.1.twbx 986.6 KB


9. Re: month on month growth
Aakash Udasi Mar 10, 2016 1:14 AM (in response to Tharashasank Davuluru)Many Thanks both of you.
This is what i was looking for