+ Reply to Thread
Results 1 to 3 of 3

Pivot Table not filtering out my zeros...

  1. #1
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    Pivot Table not filtering out my zeros...

    I have a Pivot Table set up like this:
    PT setup.PNG


    I go in to filter out any 2016 Requested that is equal to zero:
    PT filtering.PNG


    But I still see all of my zeros in the PT like this:
    PT not filtered.PNG


    So what I REALLY want is to filter out items with a 2016 Requested = 0 AND Notes = 0. But no matter what I seem to do, I can't figure out how to make the PT show me all of the lines where either there is a note or a positive number...any help would be appreciated!

  2. #2
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    Re: Pivot Table not filtering out my zeros...

    Not sure why my first two images didn't work...

    Here's the first one:
    PT setup.PNG

  3. #3
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    Re: Pivot Table not filtering out my zeros...

    And here's the second one:
    PT filtering.PNG

+ 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. [SOLVED] Filtering Data Pivot Table is Based On - Impact on Pivot Table
    By bbg22 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-17-2013, 06:34 AM
  2. displaying zeros when no value in pivot table
    By markcranmer in forum Excel General
    Replies: 1
    Last Post: 05-02-2010, 11:49 AM
  3. Data in my pivot table changes to zeros
    By MyrtlePeacock in forum Excel General
    Replies: 3
    Last Post: 01-05-2006, 10:30 AM
  4. [SOLVED] Suppress Zeros in a Pivot Table
    By Simon Shaw in forum Excel General
    Replies: 2
    Last Post: 06-27-2005, 05:05 PM
  5. Pivot Table and Zeros
    By Celeda in forum Excel General
    Replies: 0
    Last Post: 01-01-2005, 04:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1