Forum Discussion

abarnett's avatar
abarnett
Icon for Helper I rankHelper I
7 months ago
Solved

Matrix Help

Hello! I am trying to replicate a particular matrix format and I am on stuck on flipping the column hierarchy. I need the Actual and Goals to be underneath the measures. I have a calculation group ca...
Need Help
  • alish_b's avatar
    alish_b
    7 months ago

    Hi abarnett ,


    I don't think there is much help from the Calculation Groups in the expected presentation format. The calculation items (Goal and Actual) will show on the top and I believe the Column section of the matrix visual does not accept measures. 
    Anyway, I played around with a disconnected table and dynamic measure approach to come up with something as follows:

    The disconnected table holds all the possible combinations of the matrix headers grouping and the dynamic measures switches as per the scope. I think the presentation is similar to the expected one (Column totals were turned off and Sort By Another column was used in the disconnected table). However, I am afraid that this could be the same giant SWITCH approach that you were referring to. 

    Hope it helps!

alish_b's avatar
alish_b
Icon for Super User rankSuper User
7 months ago

Hi abarnett ,


I don't think there is much help from the Calculation Groups in the expected presentation format. The calculation items (Goal and Actual) will show on the top and I believe the Column section of the matrix visual does not accept measures. 
Anyway, I played around with a disconnected table and dynamic measure approach to come up with something as follows:

The disconnected table holds all the possible combinations of the matrix headers grouping and the dynamic measures switches as per the scope. I think the presentation is similar to the expected one (Column totals were turned off and Sort By Another column was used in the disconnected table). However, I am afraid that this could be the same giant SWITCH approach that you were referring to. 

Hope it helps!