I have a report where I need to visualize categorical variables in a matrix. It classifies the level of impact an issue has on a system using L, M and H. The categories also come with a numeric value of 1, 2 and 3 respectively.
What I want to do is display the categorical value of L, M or H in the matrix but have the cumulative total of the numeric values show as the row total at the bottom of the matrix.
I am not sure how to do this.
The resulting output desired:
Event System 1 System 2 System 3
Event 1 L
Event 2 M
Event 3 M
Event 4 H
Event 5 L
Total Impact 2 4 3
I enclosed a sample pbix file with fake data as I have simplified the request but the answer I can get I can expand to the real world problem.
Thank you for the help.
Event Impact Practice.pbix (26.9 KB)