
Re: To find out the growth rate of products sold for previous month or previous year
Sunny Talwar Feb 3, 2016 6:27 AM (in response to Anuraj kokkeragadda)May be something like this:
=If(Num(Month)=1,
Num((Sum([Units Sold])  Below(Sum([Units Sold]), 11))/Below(Sum([Units Sold]), 11),'#0.%'),
Num((Sum([Units Sold])  Above(Sum([Units Sold])))/Above(Sum([Units Sold])),'#0.%'))
Not entirely sure if you need 11 or 12, but I have a feeling it should be 11. If 11 doesn't work, try 12 as well.

Re: To find out the growth rate of products sold for previous month or previous year
Stefan Wühl Feb 3, 2016 6:43 AM (in response to Anuraj kokkeragadda)Look into the concept of an AsOf table to get values for previous months.

Re: To find out the growth rate of products sold for previous month or previous year
Stefan Wühl Feb 3, 2016 6:49 AM (in response to Stefan Wühl )And if you show all years, using Year and Month as dimensions in you chart, you can try just adding the total qualifier to overcome the column segment resetting.
=Sum([Units Sold]) / Above(TOTAL Sum([Units Sold]) 1


Re: To find out the growth rate of products sold for previous month or previous year
Anuraj kokkeragadda Feb 3, 2016 6:43 AM (in response to Anuraj kokkeragadda)Hi Sunny,
It was displaying the sales in jan for 2014 and 2015.
But it was displaying the sales in jan for 2013 also.Is it that according to the expression it was showing the jan sales and calculating the growth rate for previous month consequently.Is my understanding correct only?

Re: To find out the growth rate of products sold for previous month or previous year
Sunny Talwar Feb 3, 2016 7:11 AM (in response to Anuraj kokkeragadda)I am not sure what you just said. Can you may be go over it one more time


Re: To find out the growth rate of products sold for previous month or previous year
Anuraj kokkeragadda Feb 3, 2016 7:05 AM (in response to Anuraj kokkeragadda)Its displaying only from feb swuehl if i select the year 2014.

Re: To find out the growth rate of products sold for previous month or previous year
Stefan Wühl Feb 3, 2016 7:25 AM (in response to Anuraj kokkeragadda)Sure, that's why I mentioned, 'if you show all years'. If your years and month field load order is chronologic, you can try
=Only( Aggr( Sum({<Year, Month>} [Units Sold]) / Above(TOTAL Sum({<Year, Month>} [Units Sold]) 1, Year, Month))
Year and Month being your year and month field dimensions (Assuming only these two dimensions.
edit: added set analysis

Re: To find out the growth rate of products sold for previous month or previous year
Anuraj kokkeragadda Feb 3, 2016 8:11 AM (in response to Stefan Wühl )Thank You Swuehl,It was working



Re: To find out the growth rate of products sold for previous month or previous year
Anuraj kokkeragadda Feb 3, 2016 7:07 AM (in response to Anuraj kokkeragadda)Thank you everyone it is coming by modifying the expression as
=If(Num(Month)=1,
Num((Sum([Units Sold])  Below(Sum([Units Sold]), 11))/Below(Sum([Units Sold]), 11),'#0.%'),
Num((Sum([Units Sold])  Above(Sum([Units Sold]),1))/Above(Sum([Units Sold]),1),'#0.%'))

Re: To find out the growth rate of products sold for previous month or previous year
Sunny Talwar Feb 3, 2016 7:29 AM (in response to Anuraj kokkeragadda)If you got what you were looking for, do you mind closing this thread by marking correct and helpful answers


Re: To find out the growth rate of products sold for previous month or previous year
Anuraj kokkeragadda Feb 3, 2016 7:16 AM (in response to Anuraj kokkeragadda)Yaa Sunny I have entered the same expressio you told by modifying it in the last line as Num((Sum([Units Sold])  Above(Sum([Units Sold]),1))/Above(Sum([Units Sold]),1),'#0.%')).

Re: To find out the growth rate of products sold for previous month or previous year
Anuraj kokkeragadda Feb 3, 2016 8:09 AM (in response to Anuraj kokkeragadda)Hi Sunny ,
I was new to this site.I have searched the option for marked correct But i could not find it.Could you please say where that option is