Set Analysis Question

[#1]

hi,

i'm using following function to add some data:

sum( {$<Year=, Month=, YearMonthRolling= {$(=Month + Year * 100)},[Customer]={'10*'}>} Figure)

my selection is:

Year, Month and one Customer which has a 10!

Why is it that this sum adds all customers with a "10"? and not only the one i have selected? with "$" i use also the selected values? am i wrong?

[Anonymous]

Hi Corleone,

It is correct that using $ looks at the current selections, but making selections in the Set analysis statement will apply the new selections to the fields.

Example:
I have selected Continent 'Europe' and Country 'Germany'.

sum({$<Country={'France'}>} Sales)

This expression will still look at the sales for France even though my selection in the field Country is Germany.

[#3]

ok thx

i guess i missunderstood the help of set analysis!

[johnw]

You can still do what you want. You can specify an intersection with the currently-selected customers by using *= instead of = like this:

sum({<Year=,Month=,YearMonthRolling={$(=Month + Year * 100)},Customer*={'10*'}>}Figure)