on the TOTALS tab of this worksheet - i have a pivot table that is listing the YTD sales results for a sales team. I want the table to automatically sort the data as i update the worksheets so that it sorts the data by three levels
Units first
Revenue Second
SSF% Third
as of right now it is only sorting it by the units so if there are two reps with the same numebr of units, i want it to sort them by revenue, and then ssf% last.
I just can't seem to get this to happen!
Bookmarks