Hide and Show Columns in a table

[#1]

I have 25 columns in a table but I would like to have three buttons/macros which disable some of the columns so

it would be viewable. Is it possible to wirte macro about this ? / regards mikael

[#2]

Hi,

You can hide the columns in the chart properties itself.

In presentation tab, there is an option to hide the columns based on the conditions. Just check it.

[#3]

You don't need to go down the macro route with this one. Columns can only be hidden in a straight table - not a PT.

In the object properties, go to the presentation tab and you can set a conditional show for each column.

You will need to create a data island in your script (call it SelectView) and call the values something like View1, View2 and View3 (or something more appropriate).

In the conditional show, write =getfieldselections(SelectView) = View1. Now, any columns that have this will only show if you select View1 from the selection box.

This is one of a number of solutions to this.