Month on Month calculations

[#1]

Hi, I have a graph which displays the number of items for different months, there is a value for each month. I want to create another graph which will display the month-on-month for each item as a similar line chart.

For example the value for Feb would be

Month-on-Month (Feb) =   (Items in Feb) / (Items in Jan) -1

I'm having trouble getting the values for previous month for each month, have tried a few set expressions but don't seem to work. Is there any way to get the value of previous month for each month using a set expression.

Will appreciate any help regarding this

Thanks

Varun

[MayilVahanan]

Hi

May be try like this

Sum(Exp) / Above(Sum(Exp))

Month in ascending order

[senpradip007]

Hi Mayil,

Its working for continuous period. But for selected period "Above()" function is not fruitful. Pls help.

[MayilVahanan]

Hi

In that case, you need to bring "flag" for previous month.

[sunny_talwar]

Or Try this:

Sum(Exp) / If(Sum(Exp) > 0, Above(Sum({<Period = >}Exp)))

[senpradip007]

Can you please explain bit more ??