Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting on Pivot data (excel 2000)

    I may be reading the Help screens incorrectly. I have a pivot table with 2 row fields and 1 column field, with 3 data elements Units, cost and Net book value in the data fields. I want to sort by the Net book value field, but when I look at context menu or Table menus I don't seem to find out how to do that. Am I incorrect in thinking that that can be done? TYIA

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting on Pivot data (excel 2000)

    I think that what you need to do is double click on the row field that you want to sort by - probably the left-most one (in my example it is the first visible column, row 15, "sales region"), which will give you the PivotTable Field Dialog - click on the advanced button and you'll get the PivotTable Field Advanced Options Dialog. Under AutoSort options, change it from "manual" to either descending or ascending and then select the datafield you want to sort by.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sorting on Pivot data (excel 2000)

    This is how to do it in XL97 (I assume your version will be similar):
    RIght click on the field name:
    Field..
    Advanced..
    Click on ascending or descending in Autosort options

    Steve

Posting Permissions

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