+ Reply to Thread
Results 1 to 2 of 2

Pivot table - Filter by dates

  1. #1
    Registered User
    Join Date
    04-12-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    1

    Pivot table - Filter by dates

    Hi everyone,

    I have a created a pivot table in which I sum quantities of delivered products (rows). I'd like to filter the quantities/deliveries by date.

    However, the filter dates are not showing up in chronological order as shown below on the left-hand side:

    Picture.png

    As I have roughly 500 dates, this is quite a nuisance. I have tried changing the date format in the raw data to YY-MM-D so that it shows up in chronological order, but this does not solve the issue (even though the raw data now show up in the format I would like them to).

    Any ideas on how to solve this? Surely it must be straightforward to filter dates in chronological order.

    Thank you for any assistance.
    Last edited by HoyaBB; 04-12-2017 at 07:19 AM.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Pivot table - Filter by dates

    Hi HoyaBB,

    Can you post the file (or a file with dummy data if it's sensitive) that you're using with the Date Format?

    Then I can do some testing.

    Cheers
    Remember you are unique, like everyone else

+ 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. Filter recognizes dates, but Pivot Table filter does not
    By maw230 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 04:18 PM
  2. Why my Pivot Table Filter shows individual dates
    By chico.corrales in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-28-2016, 05:52 AM
  3. Macro to filter on dates in a pivot table
    By floricita in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2016, 01:35 PM
  4. VBA Code to filter rolling dates from a pivot table
    By RavenousQbert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2014, 11:28 AM
  5. Select Multiple Dates In Report Filter Pivot Table But Dates Are Not Static
    By biasedobserver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2014, 03:38 PM
  6. Filter Pivot Table between dates referenced in cell
    By tkleypas13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2013, 04:42 PM
  7. Auto update pivot table filter dates
    By kaitco in forum Excel General
    Replies: 5
    Last Post: 11-19-2010, 01:40 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