Selection based on filter

smilingjohn — Thu, 18 Feb 2021 11:47:53 GMT

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

Re: Selection based on filter

edwin — Fri, 19 Feb 2021 00:01:03 GMT

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