Get hidden column value from table column selection
I have a straight table with a few hidden columns. When a column is selected (filtered), is it possible to get the value of the hidden column?
For example, I have a table with a company name column, numerous other columns and a hidden id field. When a user clicks on a company name is it possible to select the corresponding id field? One company can have several different ids.
I figured it out. If I use an expression for the Company column instead of a dimension, it'll select the entire row when I click on the company name including the hidden columns.
