+ Reply to Thread
Results 1 to 1 of 1

sorting pivot table in levels

  1. #1
    Registered User
    Join Date
    12-29-2009
    Location
    Wilkes-Barre, PA
    MS-Off Ver
    Excel 2003
    Posts
    26

    sorting pivot table in levels

    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!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1