Forum Discussion
Matrix Visualisation with data in rows now columns
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
Hi there, this solution is a bit more flexible, as you don't have to "hardcode" your columns:
3 Replies
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
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?
Hi there, this solution is a bit more flexible, as you don't have to "hardcode" your columns:
