Forum Discussion
Unpivoting Measures
Hi!
I've encountered a scenario in which I think I need to unpivot measures and am not sure if that is possible.
In its current form, the data is displayed in a matrix like this, with each of the columns being a seperate measure:
| Measure 1 | Measure 2 | Measure 3 | |
| Location A | |||
| Location B |
The users have requested a second matrix that would ideally look like this, with each measure as its own "row."
| Location A | Location B | |
| Measure 1 | ||
| Measure 2 | ||
| Measure 3 |
Is this possible? I don't think the values would be correct if I try to replicate those measures as columns.... any advice would be appreciated!
There is a setting under Format called "show on rows" or something like that. Try under the values section.
2 Replies
There is a setting under Format called "show on rows" or something like that. Try under the values section.
Wow...thank you... clearly was making this more difficult than it needed to be!! Appreciate the heads up because I never would have thougth to check that!
