Matrix currently doesn't allow you to sort the columns based on designating values as being a priority above the column field names.
For example, my field in the columns section results in three columns. If you add two sets of values, you are forced to see: Column 1, Value 1, Value 2, Column 2, Value 1, Value 2, etc. Like in a Pivot Table, you should be able to prioritize values so that it shows as: Column 1, Column 2, Column 3, Value 1, Column 1, Column 2, Column 3, Value 2.
- Comments (73)
RE: Matrix - Sort columns by value
Requested over 3 years ago. Can Microsoft at least tell us if this basic functionality is in the funnel to be implemented?
RE: Matrix - Sort columns by value
a matrix with dates as a column - looks really weird when you sort and the dates dont sort properly - this really needs to work - or take the sort option off the columns you cant sort by
RE: Matrix - Sort columns by value
oh man ive been searching how to do this, seems like i need to vote for this, hope this will be added soon
RE: Matrix - Sort columns by value
Make my life easy please!
RE: Matrix - Sort columns by value
Really need this on the columns to sort Calendar Hierarchy in descending order for some tables.
RE: Matrix - Sort columns by value
Sorting columns in matrices by values is kind of essential.
RE: Matrix - Sort columns by value
Everyone needs this
RE: Matrix - Sort columns by value
It's crazy that this is not available yet!
RE: Matrix - Sort columns by value
It would be awesome to have this functionality!
RE: Matrix - Sort columns by value
Everyone needs this