Above() not working to obtain previous data from pivot table with 2 dimensions

[#1]

Hi,

I have a set of data where I need to obtain the previous record from the pivot table. The pivot table contains 2 dimensions ("=YEAR(MonthYear)" -->YEAR and "=MONTH(MonthYear)" -->MONTH) which is created by this field called MonthYear. To obtain the previous month's data, I use this expression: "=above(count([Complaint ID]))". Im unable to obtain the previous data for all Jan rows. Can anyone help?

[poppypearce]

Sunny Your Solution is correct but i am not able to mark as Correct as this Question was raised by Jiu Yew Loh.

Thanks  a lot for your support ....