Remove one value from dimension

[maddysalunke]

Hi All,

I am creating a table where I need to show 4 values from a field if nothing is selected , and 5 values if a filter is selected.

Ex:

Categories (Direct , Indirect , Passive , Active , ALL) -- If a filter "Grouping " is selected

Categories (Direct , Indirect , Active , ALL) -- If no value from  filter "Grouping " is selected

TIA

[Chanty4u]

Try this 

=aggr(if(GetSelectedCount(Grouping) > 0, 

        {$<Categories = {"Direct", "Indirect", "Passive", "Active", "ALL"}>},

        {$<Categories = {"Direct", "Indirect", "Active", "ALL"}>}

    ),

    Categories

)