Forum Discussion
Hiding Columns in Matrix
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.
So best practice then:
I'm getting this data based off of a SQL query. Should I just make two queries to get the data and have two separate tables, one for 2019 and one for 2020 and just use a grid? Or can I use a grid with my current data model and maybe do a pivot somehow?
This is the format my user is looking for.
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.
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!