Selections in formula versus list box: Selection still possible

[schumi1980]

Dear All,

I could not find a solution for this problem. I hope somebody can help me.

I have a formula in a table:

sum({<UnderwritingYear={'2005','2006','2007','2008'}>}[Premium])

If I now select in the table dimension only 2006, the table does not change.

How can I exclude/include in a formula values, but still be able to select/unselect values by clicking on a dimension or make a selection on a list box?

Many thanks.

Jan

[sergio0592 · Accepted solution]

Hi,

Should works with

sum({<UnderwritingYear={'2005','2006','2007','2008'}> *$}[Premium])

[alex00321]

Hi this is working well! Can you explain how it works? Thanks!

[jonathandienst · Accepted solution]

* is intersection operator

You could also use

sum({<UnderwritingYear *= {'2005','2006','2007','2008'}>} Premium)

[alex00321]

Thanks for the explanation!