Forum Discussion

ilcaa72's avatar
ilcaa72
Helper IV
8 years ago
Solved

matrix table help

hello,  i am trying to create this matrix in this format, a Dimension in column 1 that is distinct, and in Column 2, a set of repeating measures for each distinct Dimension in Column 1.  If possible....
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    ilcaa72,

    It is not possible to link each cell value to other report page as you describe, there is a similar idea about this issue, please vote it up. 

    In addition, to show measures in rows of Matrix visual, you would need to create a disconnect table as described in this blog.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

ilcaa72,

It is not possible to link each cell value to other report page as you describe, there is a similar idea about this issue, please vote it up. 

In addition, to show measures in rows of Matrix visual, you would need to create a disconnect table as described in this blog.

Regards,
Lydia

  • ilcaa72's avatar
    ilcaa72
    Helper IV
    8 years ago

    thanks Lydia.  The link to report is the least of the concerns, its a "nice to have". 

     

    the ideal would be to create this type of structured table. ill check out the links

  • ilcaa72's avatar
    ilcaa72
    Helper IV
    8 years ago

    question Lydia

     

    do you think i will be able to drop a Dimension in 1st column like my original screenshot shows?  (if you have used this before)

     

    i just dont want to go thru the process and I cant format it this way... any guidance on this issue?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      ilcaa72,

      I am afraid that it is not possible as if you add the dimension to the Measure table, how will you establish relationship between the measures based on the dimension?

      Regards,
      Lydia