+ Reply to Thread
Results 1 to 2 of 2

Sorting a second column in a pviot table messes up my first sort

  1. #1
    Forum Contributor
    Join Date
    09-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    MS EXCEL 2010
    Posts
    210

    Sorting a second column in a pviot table messes up my first sort

    My pivot table has 3 columns Name, FTE, and Base pay. I want to first sort my pivot table by Base pay from Largest to smallest and then sort by FTE from Largest to smallest. Base pay contains a persons annual Pay and I sort this one so that the Person who heads up an area is on top and the ranking follows the FTE shows either a 1 or a 0. I then want all FTE's that are zero at the bottom of the list while still maintaining the rank structure by pay. ive sorted by base first and then FTE and when I sort the FTE it moves the base pay around and I can't figure out how to maintain my first sort when sorting the second one. I have tried right clicking on a zero and moving to end but that also moves everything around.

  2. #2
    Forum Contributor
    Join Date
    09-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    MS EXCEL 2010
    Posts
    210

    Re: Sorting a second column in a pviot table messes up my first sort

    I solved my own issue by removing some of my pivot table fields and then sorting the fields I wanted to sort and then adding those other fields back in afterwards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Syntax - Control pviot table with Cell value
    By nironto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2014, 02:16 AM
  2. Replies: 6
    Last Post: 06-06-2013, 02:06 AM
  3. Replies: 1
    Last Post: 11-02-2012, 12:18 AM
  4. sorting messes up data in other worksheets
    By breteler in forum Excel General
    Replies: 2
    Last Post: 02-19-2012, 08:06 PM
  5. Sorting messes up cell references
    By Alpha Hunter in forum Excel General
    Replies: 2
    Last Post: 12-28-2010, 04:15 PM
  6. Sorting Data Messes Up Chart
    By nhrav in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-10-2009, 05:37 PM
  7. sorting master sheet messes up cells in other sheets linked to it
    By Kt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-30-2005, 07:05 AM

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