Hi all, I'm don't seem to be able to sort my pivot table by the values column.
To keep it simple, I have
Row Fields: ItemID, Description
Column Fields: Values
Value Fields: Qty, Unit Rate, Total Cost
I'd like to sort the table by Total Cost value, descending. When I attempt to sort, it merely sorts the column order, not the row values. All pointers to what I could do are appreciated. TIA, Paul
Bookmarks