Is it possible to have a list generated via a SELECT statement displayed as a REF_ROWs statement?
REF_ROWS generates a list that is displayed as an inline table which is what I would like to do with a SELECT.
OR
Can the REF_ROWS be written so that a list is generated from another column other than the key fields?
Well, no. If you have a list of Ref values, then they are effectively identifying rows in another table. So they can be shown inline as a nested table of those rows.
But if it is just a list of values, then they do not uniquely identify rows in a table. The key is the only column that is guaranteed to uniquely identify a row. You could certainly write an expression to get a list of values (eg: Row label values) and then use that to construct a list of Ref values that correspond to those via some matching expression.
I believe you are looking for a inline view which is coming from another table and without REF_ROWS. Read the list with a SELECT(TableName[KeyColumnName],TRUE) in virtual column and set the type to List and ElementType to โRefโ.
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |