Add Columns to Straight Table Dynamically without changing dimensions.

[manideep78]

Hi All,

I have a table with Column Names under Attribute Column and values Under Attribute values Column.

I want to cross the table and so that all columns names will be actual columns and attribute values will be actual values to the columns.

for every reload, the column names will keep on increasing. How can I add those columns dynamically to straight table without adjusting the dimensions every time new columns added?

P.S: I have done it in Pivot table by dragging the column name attribute to horizontal alignment. But I am trying to do it straight table and also need to use the column names & Values as filters.

ScreenShot: Please suggest how to achieve pivot table result in below Straight Table without changing dimensions every time after the realod.

[Gysbert_Wassenaar · Accepted solution]

Create a straight table with lots of measures and use expressions to get the field dynamically and show/hide it dynamically if there is no field to be shown. You need as many expressions as the maximum number of columns ever possible.

Here's an example.