+ Reply to Thread
Results 1 to 4 of 4

How to create date RANGES in pivot table report filter?

  1. #1
    Registered User
    Join Date
    04-02-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    16

    How to create date RANGES in pivot table report filter?

    I have a pivot table with dates as part of a report filter (they are NOT a row or column)

    Is there a way to modify it to let me choose like "After 4/1/2015" instead of just each individual date?

    Thanks

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: How to create date RANGES in pivot table report filter?

    No - if you want to use date filters, then the date needs to be a row or column field. Otherwise, you could add a field to your data table with a comparison like

    =A2>DATEVALUE("4/1/2015")

    And use that TRUE/FALSE as the page filter.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    04-02-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: How to create date RANGES in pivot table report filter?

    Okay I added the calculated field, but not sure what the next step is?

    Some of them show true, some show false. Some of the rows have data from before AND after the date.

    I can't use a calculated field as a report filter so not sure what to do now.

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: How to create date RANGES in pivot table report filter?

    Not a calculated field in your pivot table, but as an extra column of formulas in your data source, so that each date is evaluated. Then you can use that column of formulas as the page field, set to TRUE.

+ 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. Pivot Table - Date Report Filter
    By nathanB in forum Excel General
    Replies: 2
    Last Post: 11-28-2012, 08:40 AM
  3. [SOLVED] Pivot Table report filter
    By dabrows in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2012, 12:48 PM
  4. Replies: 0
    Last Post: 11-18-2011, 07:31 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