Filter

nimesh82

6 posts

joined Jun '10

I tried searching for this but couldn't get the answer. Is there a way to no show certain values in a filter, for example if i have a drop down containing Female, Male, Null and Not Indicated. I only want to show Female and Male. How do I do that. I already have tried going to filter and checking on Female and Male but in quick filter it still shows all the values.

Any help will be appreciated.

Thanks,

Comments

joemako

1008 posts

joined Sep '08

1. Right-click your field in the dimensions list, and select "Duplicate". This is make a copy of your field.
2. Place the "(Copy)" on the filter shelf, keeping only the values you want available.
3. Place the original filed on the filter shelf, and when you show it as a quick filter, ensure that "Only Relevant Values" is selected from the quick filter drop-down menu.

nimesh82

6 posts

joined Jun '10

Thanks a lot! That worked