Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
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..
=IF(getselectedcount(Type)=0,'Type,Criticcal,High',Type)
Sub2u444
How about this:
If(Match(Type, 'Critical', 'High', 'Type'), Type)
If(GetSelectedCount(Type) = 0,
If(Match(Type, 'Critical', 'High', 'Type'), Type), Type)
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