Forum Discussion
Combine matrix and table
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:
MFelix only on eissue. When I click on the + sign on the lowest level I get this error.
Do you know how I can work around this? The model is simple with everything in the same table, just used for this example.
Hi Anonymous ,
On the lowest level as you can see from my visualization there is no + sign, can you tell me what are the columns you are using for the hierarchy on row level.
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 🙂