Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)