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

    Advanced pivot table fields (Excel 2003)

    Looking at a Pivot table field, and choosing the Options/ Advanced options window, I see the AutoShow Top n items. I cannot get this to work for some reason. I have a number of fields organizing the report and a number of data fields. I want the "sum of Cost" data field to show me the top 50 items for the first field (Company) and presumably the row fields to the right of that Company field. Yet when I select this it does not seem to change the table. Reading the Excel help doesn't solve the issue. What are the basic rules for those settings? Do they have to be used on certain fields only, or something like that? TYIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Advanced pivot table fields (Excel 2003)

    You can set the Top n option for any row field or column field. Although you can set it for a page field, it doesn't seem to make any difference, and the option is not available for a data field.

    If you set the Top n option for a row or column field, the pivot table wil display only the entries in this field with the top n highest subtotals, the entries with lower subtotals will be suppressed. In other words, Excel doesn't look at the top n data entries, it only looks at the subtotals for the field you specify.

Posting Permissions

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