Dynamically adding columns to the Straight table.

[kalyanamharish]

I have 50 columns in a table. I need any 10 columns to be displayed as default because having entire 50 columns would make the appearance messy , as it will lead to a lot of scrolling towards right in the straight table. So any 10 columns as default initially  and options like expanding or list box to add other 40 columns to the table when required.

My efforts so far

I created a inline table of the same original table and placed this inline table in a list box with only 40 Fields.

then I created a straight table with 9 Dimensions and 1 Date measure which are not there in list box. Now I am stuck what should i write the enable condition for Dimension.

or is there any all together a different work around for this.

[vitaliichupryna]

Harish,

Check attached file, in Dimension list I have four dimensions but in dynamical table only 3 calculated dimension.

Thanks,

Vitalii

[kalyanamharish]

Thanks you very much vitaliichupryna‌ for this Example.qvw . Now I got a clear picture, i will try to rebuilt my doc in this way.

Regard

Harish