Forum Discussion
Solved
Hiding Columns in Matrix
I'm sorry for cluttering the forum a bit. Is there a way I can hide those blank and infinity columns in a Matrix visual? Not handle the blank or infinity but actually completely hide them?
Hi nsadams87xx ,
Believe that the best option is the one you already have, and hiding the columns, having seperated tables for the calculation of each year will increase the difficulty and complexity of your database.
On a related topic how would I hide the three columns highlighted yellow for FY23 whilst keeping the same columns for FY22
Hi JamesHammett ,
You need to reduce the size of the columns until they are hidden, be aware that you need to turn off word wrap for titles on columns and values.