Dynamic hiding

How to dynamically hide rows / columns / grids based on formulas ?

Written By Nikolas Ethoré (Super Administrator)

Updated at June 6th, 2022

Milliman Mind allows you to dynamically hide some rows, columns, and the headers line according to calculation results or selected dimensions/instances.

How to hide rows

To hide some columns inside a grid, you should create a new column at the right of your grid with the following header: /HideRows .

This column can contain formulas that will return for each row:

  • TRUE / 1 to hide the matching row.
  • FALSE / 0 to display the matching row.

For example :

Will be displayed like that in Milliman Mind.

How to hide columns

To hide columns, you should add (dynamically or not) the keyword &&HideColumn in your header name.

In this example Column 2 will be hidden.

How to hide the header line

If you want to hide the header line of a grid without the /NoHeader flag, simply add the text "&hide" to any of the header cells. It will automatically hide the full header line of the grid.