Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Should works with
sum({<UnderwritingYear={'2005','2006','2007','2008'}> *$}[Premium])
* is intersection operator
You could also use
sum({<UnderwritingYear *= {'2005','2006','2007','2008'}>} Premium)
Hi,
Should works with
sum({<UnderwritingYear={'2005','2006','2007','2008'}> *$}[Premium])
Hi this is working well! Can you explain how it works? Thanks!
* is intersection operator
You could also use
sum({<UnderwritingYear *= {'2005','2006','2007','2008'}>} Premium)
Thanks for the explanation!