Restricting Dimensions

[#1]

Hi,

I feel there is going to be a very obvious answer to my requirement.

I have a pivot-table with years across the top; if I select a year from a listbox I want the pivot table to only show that year and years after the selected year.  Is it possible?  if so, how would i do that?

Many thanks in advance.

C

[kaushiknsolanki · Accepted solution]

Hi,

     Try this expression,

     Sum({<Year = {">=$(=max(Year))"}>}Sales)

Regards,

Kaushik Solanki