Hiding Column(s) with Macro
In Planning Book we can hide certain columns by selecting the same with the help of Macro. This could be done with COLUMN_MARKED & COL_VISIBLE functions. In the below example we want to hide certain columns in past.
For the same we have given Icon to the macro as it needs to be executed after selecting columns.
Now select two columns which we want to hide and execute the macro by clicking on the above icon.
Result is that we don’t see those columns any more. This could be done for past bucket, future bucket (in example just took past).