Forum Discussion

nsadams87xx's avatar
nsadams87xx
Icon for Helper III rankHelper III
6 years ago
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?
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    6 years ago

    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.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

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.

nsadams87xx's avatar
nsadams87xx
Icon for Helper III rankHelper III
6 years ago

I worked with the user and got them to accept using a Matrix by having the Months as the 2nd level in the hierarchy rather than wanting an "Excel" look.  Thanks for your help!