Last 3 Years

[#1]

Hi Experts,

I want to calculate last 3 years Sales in Pivot table. Please help me how to achieve this

Thanks in Advance

[sunny_talwar]

May be use this expression:

Sum({<Year = {"$(='>=' & Max(Year) - 2)"} Sales)

[#3]

Its not working Sunny

[jagan · Accepted solution]

HI,

Try like this

Sum({<Year = {">=$(=Max(Year) - 2)<=$(=Max(Year))"} Sales)

Check this link for more options

Set Analysis for certain Point in Time

Regards,

Jagan.

[Anonymous]

hi,

Sum({<Year = {">=$(=Year(Today() - 2))"}>}Sales)

or

Sum({<Year = {">=$(=Max(Year) - 2)<=$(=Max(Year))"}>}Sales)

Regards

Neetha

[Anonymous]

Hi Abhi,

Please try like this:

Sum({<Year = {">=$(=Max(Year) - 2)<=$(=Max(Year))"}>} Sales)

Hope it helps!!

[#7]

Thank You Jagan

[#8]

Thank You Neetha