+ Reply to Thread
Results 1 to 3 of 3

Pivot Table: OR condition filter on Multi Date/Sum Filter

  1. #1
    Registered User
    Join Date
    11-09-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Pivot Table: OR condition filter on Multi Date/Sum Filter

    For example, I have a Pivot table with 'Label' and 'Date' as row labels and 'Total' as a value. I need to only show Labels if they meet either of these conditons (Total > 20 OR Multiple Dates), which would elimate A and D, but still show B and both Cs.

    See attached - Pivot Test.xlsx

    Label - Date - Total
    A - 01/01/2013 - 3
    B - 01/01/2013 - 25
    C - 01/01/2013 - 5
    - 01/02/2003 - 5
    D - 01/01/2013 - 15


    Filter to only show the following:

    Label - Date - Total
    B - 01/01/2013 - 25
    C - 01/01/2013 - 5
    - 01/02/2003 - 5

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pivot Table: OR condition filter on Multi Date/Sum Filter

    Your result example don't fit the question.

    A is not multiple and is not > 20.

    Why shoud it be shown?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    11-09-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Pivot Table: OR condition filter on Multi Date/Sum Filter

    My appoligies, I've attached the correct file. Only B and C should be displayed. B - because it's total > 20, and C - because it has multiple dates.

    Pivot Test.xlsx

+ 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] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2013, 11:01 AM
  2. Creating a condition on a report filter in pivot table
    By garywinder in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 09-02-2012, 02:38 PM
  3. 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
  4. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM
  5. Place a number filter on a report filter in a pivot table
    By reuben.doetsch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2010, 12:41 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