Set Analysis Subset Selections

[#1]

Hi,

Is it possible to restrict the values available in a chart via set analysis, but then allow the result to still be filtered on by the user?

e.g.

Department:

Finance

Supplies

Corporate

Expression:

=sum({<Department = {'Finance','Supplies'}>}cost)

This expression would sum the cost for Finance and Supplies, excluding Corporate.  If I then wanted to filter down to Finance by selecting it in a list box, it would not alter the sum.

Is there a way to make that happen?

Thanks in advance.

Tom

[sunny_talwar · Accepted solution]

This:

=Sum({<Department *= {'Finance','Supplies'}>}cost) // if you want to filter down to finance on selection

Your current expression should not alter the sum actually. Do you want it to just show Finance when you select Finance or still show both?

[#3]

Hi Sunny,

Yes, I just wanted it to show finance if finance is selected.

The new expression gets highlighted with a syntax error, but it works as I want it to.

Thanks

[coloful_architect]

I had same issue..but why sometimes the set expression seems to allow me to delve into the subset of filter , in this case "France" , but sometime it does not...  I thought that $ sign always allows to select other dimensions...only 1 is to lock.