Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    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:

     

MFelix's avatar
MFelix
Super User
5 years ago

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:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    MFelix  Thank you! That turned out perfectly 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • MFelix's avatar
      MFelix
      Super User
      5 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        MFelix 

         

        Report:

         

         

         

        Visual:

         

         

        Data: