Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have an expression added to multibox ...Under presentation im unable to locate expression to enable hide excluded option .
Please suggest.
Hi, In presentation tab select the field which you required and then check Hide exclude option
It is not direct field...I have added an expression which is not visible under presentation tab.
Yes, for the Expressions in the multibox you cant give an option Hide Excluded. please tell me your requirement in detail so that I can give an alternate way which might be helpful for you
What I'm trying to do is create a dynamic filter Type ={A,B,C} as values using inline table...
Suppose if I select Type as A.....Only {A,B,C} possible values should be available in next filter
Ex1: Filter1 ....A
Filter2 ....{A,B,C}
Ex2: Filter1 ....B
Filter2 ....{1,2,3}
Please suggest...Currently I'm using following expression for filter 2 which is displaying all possible values which is not our requirement
Filter2 =if(Type ='A',[Column A],if(Type= 'B',,[Column B],[Column C]))
Data is shown below
Column A | Column B | Column C |
A | 1 | Y |
A | 2 | Y |
A | 3 | Y |
A | 4 | Y |
A | 5 | N |
A | 6 | N |
B | 1 | Y |
B | 2 | Y |
B | 3 | Y |
B | 4 | Y |
B | 5 | N |
B | 6 | N |
C | 1 | Y |
C | 2 | Y |
C | 3 | Y |
C | 4 | Y |
C | 5 | N |
C | 6 | N |