Forum Discussion
Solved
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'...
Hi there, this solution is a bit more flexible, as you don't have to "hardcode" your columns:
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: