Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create matrix with main columns headhers and two subcolumns (budget and actuals).

Hello,

 

I am working on a budget reporting tool, where I have the following datasets:

 

1. Main dataset with Cost ID, Category ID, Budget 2020, Actuals 2020 (Budget)

2. One table where each Cost ID is matched with a cost Department (Departments)

3. One table where each Category ID is matched with a cost category (Category)

 

Since Cost ID and Category Id do not mean much for most people, I want to have a matrix, like the one shown below, where each row represents a category (this comes from the one to many relationship between Category and Budget tables) and each column has a main header which is the Department (this comes from the one to many relationship between Departments and Budget tables), as in the picture below, and then I would like two ramifications represented but "Budget" and "Actuals 2020" (they come from the main budget dataset)

 

 

I know that I can create multi-row-level but after looking around, I found no way of doing the column trick and I am afraid that it is not even possible. I hope this is clear enough, otherwise, I am happy to answer more questions.

 

Thanks a lot!

 

  • Anonymous , Category as row, Department as Column and Budget 2020, Actuals 2020 as values in the matrix, should give this kind of display. I am missing some details

2 Replies

  • Anonymous , Category as row, Department as Column and Budget 2020, Actuals 2020 as values in the matrix, should give this kind of display. I am missing some details