How to achieve this using 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!

[lironbaram · Accepted solution]

hei

attach is an example of what you asked for

the expression goes like this

assume the user select values in the company field

sum({<company=E(company)>} Sales)

hope its helps you

[#3]

Hi Liron, thanks a lot for your help! I have another problem (Please refer to this post). Would you mind to help me? Thank you very much!