To calculate amount in Current Month - amount in Previous Month

[manisha10]

Hi All!

I have to calculate  the difference of Amount in current month with the Amount in previous month. 

when March is selected  = Amount for March - Amount for Feb

when Jan is selected = Amount for Jan 

right now when I select in the filter more than 1 month, I'm getting the values. 

if I select Feb to April, I'm getting the values. 

[vinieme12]

if you have yearmonth as dimension then you can try this

Sum(Amount)- aggr(above(Sum({1}Amount)),YearMonth)