+ Reply to Thread
Results 1 to 6 of 6

Dates filtering in pivot tables

  1. #1
    Registered User
    Join Date
    12-11-2017
    Location
    Prague, Czech Republic
    MS-Off Ver
    2016
    Posts
    7

    Dates filtering in pivot tables

    I have a pivot table where I have products and then dates when we are expecting additional supply arrivals. Is there a way to filter the dates in the pivot in a way that the incomes will always start tomorrow (if I was looking at the dates today, December 15, the incomes would start with December 16, if on December 16, the incomes will start on December 17, etc.). I can see there is a range of dates but you always need a starting point and I would like that to be automatic, with no end.

    It is similar to this table, just a pivot table.

    MATERIAL EXPECTED_DELIV_DT
    Product A 12/30/17
    Product B 1/16/18
    Product B 3/12/18
    Product C 4/2/18
    Product A 5/28/18
    Product C 7/31/18
    Product A 9/17/18

    Is something like that possible?

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

    Re: Dates filtering in pivot tables

    Quote Originally Posted by katerina_kc View Post
    I have a pivot table ...
    but we don't have

  3. #3
    Registered User
    Join Date
    12-11-2017
    Location
    Prague, Czech Republic
    MS-Off Ver
    2016
    Posts
    7

    Re: Dates filtering in pivot tables

    Here it is.
    Attached Files Attached Files

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

    Re: Dates filtering in pivot tables

    you can group by days then select 16 Dec
    but
    you should show (except source PT) result PT what you want to achieve (manually created)

  5. #5
    Registered User
    Join Date
    12-11-2017
    Location
    Prague, Czech Republic
    MS-Off Ver
    2016
    Posts
    7

    Re: Dates filtering in pivot tables

    Sorry, I wasn't clear in my question. Our reports use the Global refresh to update the pivot table with the most up-to-date information. What I need is to have the income dates always starting the next day without me having to manually set it up. Is that at all possible or do I have to do it manually every time?

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

    Re: Dates filtering in pivot tables

    Could you attach file with:
    a) source, dummy data
    b) before - like above
    c) after - what you want to achieve

+ 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. Replies: 0
    Last Post: 07-29-2015, 09:41 PM
  2. Filtering data from tables using pivot tables
    By DaddioPlus in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-05-2015, 01:25 PM
  3. Pivot Tables - Filtering
    By tmanch in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-12-2014, 03:46 PM
  4. Filtering in Pivot Tables
    By bat069 in forum Excel General
    Replies: 1
    Last Post: 08-24-2011, 04:19 AM
  5. Filtering Pivot Tables
    By Smonczka in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 01:40 PM
  6. Filtering within Pivot Tables
    By Meares in forum Excel General
    Replies: 0
    Last Post: 08-09-2005, 10:05 AM
  7. [SOLVED] Filtering pivot tables
    By Darren in forum Excel General
    Replies: 2
    Last Post: 04-13-2005, 05:06 AM

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