Non associated values required in a new list box

[shmkmr90]

Hi,

My requirement is,

Scenario 1:

A dimension in list box is selected with some values, i want to view the non associated values of the same dimension in another listbox (for just view only purpose). is this possible?

for example, I have an year dimesnion with {2014,2015,2016,2017} values. when 2014 and 2015 are selected in list box A, there will be 2016,2017 greyed out. i want these values to be seen in a separate list box.

Scenario 2: If it cannot be possible in a new list box, can we have it in a textbox level concatenated or some other way?

Thanks,

Shyam

[jwjackso]

If you use a text object,

=Concat({<Dim1=E(Dim1)>}Dim1,Chr(10))

[shmkmr90]

Thank you Jerry. It is working in a text box. Can't we have in a list box? Although it is for View only, List box seems a look good than a text box. isn't it ?

[jwjackso · Accepted solution]

I'm not sure about another list box, but you could use a straight table.  In the expression:  =if(Count({<Dim1=E(Dim1)>} Dim1) > 0,1,0)

Hide the expression column, suppress zero-values, no totals, no caption.

[shmkmr90]

Thank you Jerry. It looks great.