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

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