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.

[settu_periasamy]

Hi,

Check this..

Show Today's Sales and Same Day Last Year's Sales

You can try to use with Above ()..

[sunny_talwar]

This?

Expression for Previous Month:

=Before(Sum(Act_Amt))

[sunny_talwar]

I think you might not have opened the attachment. The chart used is a pivot table and required to use Before() function to get the previous value.

[settu_periasamy]

Yes.. I'm posted using my mobile.. thank you..

[sunny_talwar]

[kavita25]

It doesnt work on selection....it gives null...

[sunny_talwar]

What selections are you making?

[sunny_talwar]

Try this expression:

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

[kavita25]

On click, its working now, But If its Jan it should show for Dec Previous Year...Now its showing null