How to filter dropdown fixed value data

[Farsana]

Team,

Created a dropdown box with fixed values: "All, Audio, Video, Sync".  In table i have a  one dimension field named as Modality contains value as Audiosession, videosession, sync. If i selected "ALL" from drop down the table should display all records, if video only videosession and so on. How to do it. Any sample for reference.

Thanks in advance

[Vegar · Accepted solution]

Add a dimension table like this.

Load Modality,

Subfield([Select modality],'|') as [Select modality]

inline [

Modality, Select modality

All, Audio|Video|Sync

Audio,Audio

Video,Video

Sync, Sync

];

Then use the "Select modality" when filtering your data.

[Farsana]

Thank you @Vegar , You made it simple. It worked. Thanks much