Matrix Visualisation with data in rows now columns

[JamesCH]

Hi all

I have some data on sales values and volumes that I need to display. Using a matrix I can get them all on one row (see first table below) but I want to show 'value' on one row and 'volume' on the next. (see table 2 below). There does not seem to be an easy way to do this. Any ideas

[BhaveshPatel]

Please follow along the screenshot to see the expected results. 

Do not promote headersReversed RowsTransposed RowsUse a fill down feature under Transform TabCreate Conditional column for Sorting of the month name by month no.Final results

[JamesCH]

hi thanks for that.

The data I have is already in a table and is selected via a slicer. What I don't understand from your solution is how I get that data into this table in the first place?

[ImkeF · Accepted solution]

Hi there, this solution is a bit more flexible, as you don't have to "hardcode" your columns:

https://bondarenkoivan.wordpress.com/2016/10/07/how-to-organize-measures-in-tables-horizontally-in-p...