topic Re: Problem in calculating Growth% by Month-Year in App Development

Problem in calculating Growth% by Month-Year

rohitk1609 — Wed, 13 Dec 2017 06:01:33 GMT

Hi Techies,

I am facing a problem while calculating growth% by Month-Year in Table chart. The result I am expecting is :

Month-Year KPI Growth%

Jul-2017 A 10%(Val of Jul-2017 / Val of Jul-2016 -1)

Jul-2017 B 20%

Jul-2017 C 30%

Aug-2017 A 10%

Aug-2017 B 20%

Aug-2017 C 30%

Formula I am considerng is : July 2017 Sales/July 2016 -1

Please let me know how to do it

Thanks in advance

Best,

Rohit

Re: Problem in calculating Growth% by Month-Year

its_anandrjs — Wed, 13 Dec 2017 06:05:23 GMT

And which type of chart you are using.

Re: Problem in calculating Growth% by Month-Year

rohitk1609 — Wed, 13 Dec 2017 06:09:59 GMT

tabular or pivot anyone but I need to use Month-Year dimension and one other dimension and in measure I need to find the growth as this month 2017 by this month 2016

Re: Problem in calculating Growth% by Month-Year

its_anandrjs — Wed, 13 Dec 2017 06:24:41 GMT

May be try with Variables or straight table will give correct result.