Forum Discussion
Combine matrix and table
I have a matrix with a project hierarchy in one column, but is it possible to also show parametres in a second column? The data looks like this: Project Lvl 1 Project Lvl 2 Produkt Name ...
Hi Anonymous ,
To what I can see from the image you provide you want to have an additional row in the headers but the value in the values.
Add a column with blank values to your model then just put your matrix in the following setup:
- Rows:
- ProjectsLevel1
- ProjctsLevel2
- BlankColumn
- Values
- FirstProduct Name
- Sum ProjectCosts
- Turn off subtotals
Result below:
- Rows:
Hi Anonymous ,
I have the exact same setup and everything is working properly, except when I do one thing that is to have the blank value from another table that will return the same error you data should look like this:
As you can see I have the blank column in the same table that will work properly.
MFelix Thanks 🙂