Show previous month data

[deepakkrish]

Hi all

        In pivot table  how to show the previous month data without any filter selections.

I have a date and month fields.

Thanks

Deepak

[Eugene007]

Hi there, I am also trying to show previous months data, here is my current expression, what do I need to apply to change the results?

SUM({<DateKey = {">=$(=Min({<FYP = {"$(=$(vCurrFYP))"}>} DateKey))<=$(=NUM(Date(vToday)))"}, FinancialCode =- {9999}, ProfitCentreCode = {2}, Date= >} RoomsSold)