Column values into list

[Anonymous]

Hi,

I'm hoping this isn't too difficult but I have two simple filters - Region and Country. By selecting the Region and Country, I would like the user to see which types of paper to print on (e.g. A3, A4, Flyer, Poster etc).

Here are my filters for selection:

So for example when selecting 'EMEA' and 'UK' the following appears - which shows only 3 types are needed.

Question - how do I show the output from a user selection as a simple list?

E.g. from the selection above, I just want a box which shows:

Flyer

A4 Paper

A3 Paper

Your help is really appreciated!

Mark

[lorenzoconforti · Accepted solution]

Maybe just create a textbox with something like this in it:

=if(not(IsNull(only(Flyer))),'Flyer') & chr(13) &

     if(not(IsNull(only(A4 Paper))),'A4 Paper')

and so on

[vishsaggi]

As Lorenzo suggested just try like below in your Text object as another option

= Flyer & Chr(13) &

   [A4 Paper] & Chr(13) &

   [A3 Paper]

[MarcoWedel]

What if your selection leads to multiple rows in your table?