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...
If you are looking to compare actual against budget, you want to make sure the relationships between the tables are set up correctly. Also, you want to consider the granularity between the budget and the ledger tables. For example, if the budget data is at a monthly level and the ledger data is at a daily level, you need to ensure that the aggregation in the matrix makes sense for both.