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.
Bookmarks