How to show current month and previous in the same table with month as a dimension

[kavita25]

Hi,

I want to show Current month Sales and previous month sales with the month as a dimension..

Its Urgent...

Please provide ur solution ASAP.

[sunny_talwar · Accepted solution]

Check this:

=If(Sum(Act_Amt) > 0, If(Num(Month) > 1, Before(Sum({<Month, [Month Year], Date, Year>}Act_Amt)), After(Sum({<Month, [Month Year], Date, Year>}Act_Amt), 11)))

[kavita25]

Thanks a lot..Sunny..

Really appreciate ur help.....

It worked..

[kavita25]

Hello Sunny..

How will I restrict data for current month & previous two months for the same table.

Plzz..help me with this.

Regards,

Kavita