Forum Discussion
Matrix Help
- 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!
Hi abarnett,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.