Forum, Tips & Tricks

Learn tips and tricks and engage in discussions with our blog authors here. It’s all for your benefit and learning. 

You need to log in to create posts and topics.

How to hide columns in Matrix

Problem:

By default when you try to hide columns in matrix  the height of the column header increases significantly (depending on the name of the column). In example bellow I tried to hide  column  “Plán“ because the data for 2017 is not available.

Before

Solution:

Select matrix and in format part in Column headers and Values you have to set Word wrap to off. (Note: should you have all nulls in column you want to hide it is sufficient to turn off Word wrap in column headrs

After