Selection based on filter

[smilingjohn]

Hi All, 

I have a table which gives the information about Department, viewers, total profit 

Within this table i want to display fileds cricket_team or Wrestling_team. 

To do so I have a cretaed a inline table in the script which is GameType( Cricket , Wrestling) 

and the list box is like 

GameType

Cricket

Wrestling 

When I select Cricket the table should show me Cricket_team filed and if I select GameType Wrestling then the Wrestling_team should be displayed . 

Whihc I am achiveing by this condition 

=if(GetFieldSelections([Game Type])='cricket',Cricket_team,wrestling_team)

Here I need to show how do we include both the fields when i select bot the GameType in the filter selection ? 

Thanks

[edwin]

if what you intend to do is add the two fields CricketField and WrestlingField in the dimension, you can use conitions for both fields:

for CriketField, condition is =if(SubStringCount(Concat(DISTINCT GameType),'Cricket')>0,1,0)

for WrestlingField, condition is =if(SubStringCount(Concat(DISTINCT GameType),'Wrestling')>0,1,0)

if both are selected, both fields will show