I have 2 dimensions, in that one is Type as "Safety, Critical, High, Medium, Low".
Initial with out any selections i want to show only first three, else five.
I tried the below condition, check..
How about this:
If(Match(Type, 'Critical', 'High', 'Type'), Type)
If(GetSelectedCount(Type) = 0,
If(Match(Type, 'Critical', 'High', 'Type'), Type), Type)
thank you Sunny
Retrieving data ...