Right now if I have a pivot table showing revenue and the rows have the customer name and the columns show the product name the product names will only appear in alphabetical order regardless of the revenue value of that product. The columns should be able to be sorted dynamically based on the value of the revenue or whatever metric is included.
dynamically sort pivot columns based on values
No CommentsBe the first to comment