Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
May be try like this
Sum(Exp) / Above(Sum(Exp))
Month in ascending order
Hi Mayil,
Its working for continuous period. But for selected period "Above()" function is not fruitful. Pls help.
Hi
In that case, you need to bring "flag" for previous month.
Or Try this:
Sum(Exp) / If(Sum(Exp) > 0, Above(Sum({<Period = >}Exp)))
Can you please explain bit more ??