Forum Discussion

abarnett's avatar
abarnett
Helper I
6 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...
  • alish_b's avatar
    6 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!