Is there a way to set a selection within a chart?

[#1]

I need a chart that shows ONLY STEELS, which is one of the 2 choices for Metal Category. I have tried this:

If(([Metal Category] = 'STEEL') OR (AlloyFamily <> 'OTHER'), AlloyFamily, ' ')

but ALL the AlloyFamily members still show up, including OTHER. If I do a list box for Metal Category and select STEEL, I get what I am looking for but it affects the entire tab and NOT just the chart I want it to. Any ideas?

[sunny_talwar · Accepted solution]

Try it using set analysis:

Lets say your current expression is Sum(Sales) -> Change it to Sum({<[Metal Category] = {'STEEL'}>}Sales)

[Colin-Albert]

Set analysis is one way as suggested by Sunny.

Another option is to use Alternate States so the Metal Category can be selected for objects defined to use that state.

[#4]

Set Analyst worked great. Thank you.