Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)))
This?
Expression for Previous Month:
=Before(Sum(Act_Amt))
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.
Yes.. I'm posted using my mobile.. thank you..
It doesnt work on selection....it gives null...
What selections are you making?
Try this expression:
=If(Sum(Act_Amt) > 0, Before(Sum({<Month, [Month Year], Date, Year>}Act_Amt)))
On click, its working now, But If its Jan it should show for Dec Previous Year...Now its showing null