String in expression, one row for each string

[#1]

Hi All,

I have to show String value in expression with one value for each row, I could have used Only function but since the String values are multiple for one dimension value, only is returning null, please help.

1. Cant use calculated dimension, as selection will result in multiple items in current selection box<Hide using _ prefix, but not recommended>

PFA the demo app.

Regards,

Navdeep

[rubenmarin]

Hi navdeep, you'll need a dimension that creates the rows so it will be easier keep your table with the 1's and hide this column (In presentation tab) and remove totals.

Another option is using a Table Box.

[#3]

Hi Ruben,

Setup is in such a way that I cant use it in dimension and unfortunately straight table is again not an option, please suggest something else.

Regards,

Navdeep