Rolling last month of last Year

[sivasiri99]

Hi,

I need an expression to roll  Last year last month data in pivot table eg(2015 12 mnth ).

i have for the current month expression:

=Sum({<MonthNum={"$(=Max({<Flag={'Link Master'},Year={'$(vCurrentYear)'}>}MonthNum))"}>}[Ending Balance]/1000)

Regard's

sivaram.

[sunny_talwar]

May be this:

=Sum({<MonthNum={"$(=Max({<Flag={'Link Master'}, Year={$(=Max(Year) - 1)}>}MonthNum))"}, Year={$(=Max(Year) - 1)}>}[Ending Balance]/1000)