Set Analysis, I want current selection to affect the data

[ziabobaz]

Hi,

I have the following expression:

sum( {$<Season=('*winter')>} SALES )

..and it shows me the Sales disregarding current selection in the filter 'Season'. I want to show Sales for all seasons containing "winter" when no selections are made in the filter 'Season', but I don't want to show sales, when the season selected by the user does not contain "winter" in it's name.

Isn't the '$' sign supposed to solve the problem?

[sunny_talwar · Accepted solution]

Try this:

Sum({$<Season *= {'*winter'}>} SALES)

Implicit Set Operators

[ronnyhu]

This solution hardcoded "winter".

What if I want to use selected Season, it might be Spring, Summer, Autumn, Winter? What is the correct expression? eg Sum({$<Season *= {'*SelectedSeason???'}>} SALES) ?

Please help