+ Reply to Thread
Results 1 to 2 of 2

Pivot table label filter not filtering out all data

  1. #1
    Registered User
    Join Date
    04-08-2020
    Location
    Seattle, WA
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Pivot table label filter not filtering out all data

    I have a pivot table for lab test values that number 10-600. The column label is the lab value and I need to figure out how many results are in specified ranges. When I apply the label filter for some of the ranges, it is not working. For example, I need to see how many results are >=70, and it correctly filters out only results that are 71-99, but also shows results >=100.

    When I apply the >200 label filter, it works for results 100-600 and shows only results >200 in that range, but doesn't filter out anything <100. Is seems like the data is being split somehow between 99 and 100.

    I have done this before with a smaller data set and it has worked so I am lost at what to do.

    Any help is greatly appreciated!

    Thanks, Amanda

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Pivot table label filter not filtering out all data

    I suggest adding a helper column to the source data. Look into VLookup with the TRUE option. It's a great way to sort things into buckets.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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: 10-03-2016, 04:16 PM
  2. Filter Pivot Table Label via VBA
    By cantona_lives in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2015, 05:46 AM
  3. Replies: 6
    Last Post: 01-07-2014, 03:24 PM
  4. multiple label filter in pivot table
    By pma85 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-23-2013, 08:45 AM
  5. I want to filter every Pivot table on the same row label
    By pkiron33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2013, 06:10 PM
  6. Filter Pivot Table Row Label by Another Row Label
    By bdcelli in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2013, 12:57 PM
  7. filter a pivot table row label from vba,
    By cesna123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2010, 05:07 PM

Tags for this Thread

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