Show values for months not selected

[schumi1980]

Hi All

How do I write an expression in a pivot table that shows the values that are not selected by a list box/current selection for a certain dimension:

For example:

I choose months 1-3, I need the expression to show months 4-12.

Is that possible?

Many thanks.

Best regards,

Jan

[marcus_sommer · Accepted solution]

You could use something like this: sum({< Month = e(Month) >} VALUE)

- Marcus