+ Reply to Thread
Results 1 to 2 of 2

Filtering specific individual dates in PivotTables with changing input

  1. #1
    Registered User
    Join Date
    07-18-2017
    Location
    Sweden
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Filtering specific individual dates in PivotTables with changing input

    How do I filter data for specific individual dates in a PivotTable? The input is changed on a weekly basis and therefore the specific desired dates will change every week. I have data for every business day. And I want to retrieve data from the most recent business day, 5 business days before that, 30 business days before that and 90 business days before that. How do I go about this?

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Filtering specific individual dates in PivotTables with changing input

    I don't remeber if it exist in Ex2010 but ....

    On date column in Pivot Table select drop-down arrow then select Date Filters and choose what you want or define your own.

+ 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/deleting rows based on numerous individual index dates
    By PineCone in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-20-2017, 09:24 AM
  2. Filtering Pivottables
    By j_Southern in forum Excel General
    Replies: 0
    Last Post: 09-26-2012, 05:11 AM
  3. [SOLVED] Changing Data Source in PivotTables
    By nirvehex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-23-2011, 04:50 PM
  4. Changing cell values on specific dates
    By dradford in forum Excel General
    Replies: 8
    Last Post: 05-09-2009, 09:13 AM
  5. Excel 2007 : Changing cell values on specific dates
    By dradford in forum Excel General
    Replies: 1
    Last Post: 05-09-2009, 07:19 AM
  6. Changing source of PivotTables in XL2003
    By lalbatros in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2007, 09:47 AM
  7. [SOLVED] PivotTables - Group Dates, excluding dates
    By Todd1 in forum Excel General
    Replies: 4
    Last Post: 12-10-2005, 01:10 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