Forum Discussion
Matrix Help
Thank you in advance. I have a dataset with the following relationships: and I'm trying to create a matrix that will have a Heirarchy of Cost Type > Account Name/Subcontractor Classi...
Hello! Hello! \o/
One option to achieve this would be creating a new calculated column in the Ledger table that decides whether to show the Account Name or the Subcontractor Classification. In the example below, I'm calling the new column Second Level, please make sure to give it a proper name. Also, please remember that calculated columns will add up in the storage size.
I hope that helps.
When I use this column in my matrix along with values from the budget table (see diagram above) I get a slew of duplicate values.