+ Reply to Thread
Results 1 to 2 of 2

Filter top 5 records in pivot table

  1. #1
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    354

    Filter top 5 records in pivot table

    Hi,
    I have attached my Excel file.

    sheet "PIVOT TABLE." contains pivot table of entire data and sorted in Column L on descending order.

    in sheet "PIVOT TABLE-TOP 5" I tried to Value filter top 5 records based on the values on column L.

    But one record is not coming in top-5 even though it falls under top-5

    That particular row is highlighted in yellow color sheet "PIVOT TABLE."

    May know why that record is not coming? can any one help me on this?
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,592

    Re: Filter top 5 records in pivot table

    The Top N items are based on the field Amt2 and not the Amt2 AND 'year segment=3'.
    So it's top N overall not within as displayed on the table.

    If you apply Total Column you will see the Top N items match
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 1
    Last Post: 02-25-2018, 09:47 PM
  2. Two pivot tables with the filter of pivot table 2 to automatically update to filter 1
    By StefaniaLa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2018, 06:19 PM
  3. Inserting filter into pivot table via macro errors if filter doesn't exist.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2018, 10:24 AM
  4. Pivot Report doesn't show current records but they are in pivot table
    By dixiecricket in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-16-2015, 11:25 AM
  5. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  6. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 PM
  7. Replies: 0
    Last Post: 05-09-2006, 03:40 PM

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