How to have some values in filter to be static and some to be dynamic

Question

Hi, i want to differ my filter elements into mandatory and optional data. I want data to be selected from optional by user and mandatory to be hidden. so user cannot uncheck them. how to do this?

Answer 1

Hi Nithin,

1. You can form group of those you require  to be mandatory and the vice versa using calculated field.

2. Now add the values that you require using any aggregation or a check operation and form groups.

3. Now add the group that you want optional in filter and place the field in row/ column shelf.

Hope this helps you.