How to hide certain expressions depending on selections

[#1]

Hello all,

I'd like to have in a pivot table or straight table to display only expressions IF they match certain selections.

eg.

If I choose January it only shows values for Jan. But if choose another month (eg Sep) the table should display all the month till Sep.

Oct, Nov and Dec shouldn't be display in my table.

Can anyone have any idea on how to solve this?

I'm using QV9.

Many thanks.

Joao

[#2]

You should use in your expressions:

Month={"<=$(=Num(Month))"}, Year={$(=Year)}

[Miguel_Angel_Baeyens]

You'd better use (untested)

Month={$<"<=$(=Num(Month())">}, Year={$<$(=Year)>}

to add set conditions to your expressions, but note that $< before functions and fields, meaning "add to current selection".