Unpivoting Measures

[rachelbabcock]

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!

[rachelbabcock]

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! 

[MattAllington · Accepted solution]

There is a setting under Format called "show on rows" or something like that. Try under the values section.