How to do this in set analysis?

[#1]

Hi, in my application, there is a list box for user to choose which companies they would like to exclude from the chart. My chart is used to display the total revenue of each company for each fiscal year. How should i write the set analysis in order to achieve the purpose of excluding those companies selected by the user? Thanks much, I really need a solution asap. Thanks in advance!

[mazacini]

If I understand correctly, you want to select companies from a list box, and exclude those selections from a chart, which I assume will default to show all companies?

Could you use sum({1-$}Revenue). This will give the inverse of the current selection ie everything that the current selection excludes.

Note that if you are selecting on more than one dimension, it will exclude those selections as well.

[SunilChauhan · Accepted solution]

try this

=if(getselectedCount(fieldnamein seleection)>0,Sum({1-$} Revenue),sum(amountfieldname))

or see the attached file for example