Forum Discussion
Matrix visual challenge
Hi there, hope someone can help me with the visualization of my matrix. I put my fields in like this: Then, I get this result: Does anyone know if I can have this result and how to ...
Not easily.
Easiest thing would be two Matrix next to each other and hide the first column of the second Matrix.
The hard way would be creating a new column with the names of the two measures in it.
Then use this in your coulmns and drill down to m/v.
Create a measure for each seperate calculation.
Write a measure that tests the current column value and returns the corresponding measure.
It would be nast and hard to maintain.
Hi SamWiseOwl, thanx for your reply. I tried Audrey's solution.