I have a pivot table that needs to be able to be sorted by any column selected. How do I sort by values? It keeps grouping the row names before sorting the values. So it will group by date, and then session for that date. I want the dates to be mixed and just give me top session value. If this isn't possible to do within a pivot table, can anyone recommend an alternative solution?
Bookmarks