Conditional List Box?

[#1]

I have a list box that allows selection of campaigns on several tabs. Each tab will only contain data from certain campaigns but the list box shows all possible values (not specific to the tab). Is there a way to make the list box contain campaigns only applicable to the tab I am on?

[Anonymous]

you need to set a flag if there isn't already a way/logic to how the campaigns are assigned to a specific tab. then you can use set analysis to show only the specific campaigns on each tab. post a sample data set if possible, and we can help you come up with the exact expressions.

[#3]

You can mention the condition to display only particular campaign in the list box using expression in listbox ("General" tab -> Field dropdown -> Expression)

[rwunderlich]

One way to filter dimensions in a list box is with aggr() like this:

=aggr(only({<Type={email}>}Campaign), Campaign)

Where "Type={email}" is some sort of filtering condition(s).

-Rob

http://masterssummit.com

http://robwunderlich.com