+ Reply to Thread
Results 1 to 3 of 3

Pivot Table filter is not working as expected

  1. #1
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Pivot Table filter is not working as expected

    In the attached workbook you will see that there are negative values for some customers in the pivot table.

    In a previous thread I was helped with how to display only customers with a value in Sum of Overdue which worked OK. However, I now need to eliminate these negative values. Setting the Sum of Overdue filter as Greater Than 0 does not work for me.

    I would greatly appreciate any help please.
    Attached Files Attached Files
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Pivot Table filter is not working as expected

    Have you considered using a helper column with an If test to replicate the overdue numbers that are >0?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Pivot Table filter is not working as expected

    Thanks for your suggestion Richard. I've solved it by removing negatives from the data in the Overdue column in the invoices table. Much better data mangement!!!

+ 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. Expected table is not in the expected format - ADODB Connection to Read Only Excel file
    By Roshan10043 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2018, 10:54 AM
  2. Pivot table filter not working right
    By ryangodammit in forum Excel General
    Replies: 2
    Last Post: 10-07-2014, 05:00 AM
  3. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  4. Pivot Table Filter Macro Not working
    By sm9748 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2013, 03:43 AM
  5. 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
  6. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  7. [SOLVED] Pivot Table Wizard Error (Expected 52)
    By Guest in forum Excel General
    Replies: 0
    Last Post: 04-28-2006, 05:15 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