Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

multiple description columns on a matrix table

Dear,

 

I have an issue using multiple description columns to described one unique item on a matrix chart

on my table (on the left), item1 and description 1 have a one to one relationship 

 

When i  create a matrixtable with the 2 columns as row description , that create hierarchy relationship that i dont want

so either i need to remove column2 from my table ( right dowm) either i have to delete the column sum  (right up)

 

Is there a way to add a column in matrix table that is only for description and not in the hierarchy 

 

Thank you for your support

  

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    Thank you Dale for your reply.

    I finally remove the "stepped" option in the row header format option

     

     

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Anonymous,

     

    Is the result below what you want?

    Column1             Column2          Column3            Column4

    item1                description1           01/18               100

                                                            02/18               200

                                                            03/18               100

    item2               description2            01/18               200

                                                            ...                     ...

     

    If so, I'm afraid it's hard to get it. What's the original data?

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you Dale for your reply.

      I finally remove the "stepped" option in the row header format option

       

       

    • Zoravor's avatar
      Zoravor
      New Member

      Hi,

       

      Your solution is not visible on the forum.  Can you please repeat?  I 'm looking for the same solution.  Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI all i m not familiar with the forum,

     

    is there anything I missed in my post in order to have an answer?