I have created a dynamic straight table that allows user to select what columns they would like to include. If they continue to add columns to the table, it will keep growing to the right and go off the side of the screen. I would like a way to limit the size of the chart so a scroll bar will appear inside the chart after it reaches a certain size.
Thanks very much
I think this isn't possible and believe that's general better to limit the count of dimensions itself - maybe 3 or 5 or 7 possible dimensions and an additional other table without flexibilisation and (all) dimensions which users could export if they really need dozens of dimensions (and calculations).
Thanks for the reply. The purpose of it is to be a report builder, so users can easily make a table with the info they need and export it to excel so limiting the dimensions isnt really an option.
Not yet. Don't quite know what you mean. Move all the dimensions to be expressions? i will try but i have calculated conditions for 30 fields so will be effort to make that change.