Sort by individual column values in a matrix
If I create say matrix with employees on rows and months on columns with expenses in values, I currently cannot sort by a particular month to see who were the top spenders in that month. I can only sort the totals.
Excel allows sorting on individual column values. Need similar functionality in the matrix as well.
Min Zhang commented
My customer also hope can have this feature.
This would be extremely useful!
Yes, this is basic feature which should be included.
I total agree
I agree that this would be very useful. The default action of filtering is counter intuitive when clicking on the value header(s), and of course is a different action to selecting the totals.
Filtering only really makes sense when clicking on the column values above the value header(s).