+ Reply to Thread
Results 1 to 3 of 3

Pivot table report filer - dates & grouping

  1. #1
    Registered User
    Join Date
    03-23-2017
    Location
    Northern Ireland
    MS-Off Ver
    Office 2010
    Posts
    24

    Pivot table report filer - dates & grouping

    I have a lot of data with date times of jobs done (DD/MM/YYYY HH:MM) and i need to filter the resulting pivot table by date. The issue is when i create an extra column in my data to show a date time cell as just a date (DD/MM) and add it as a report filter, i get a list with multiple same dates on it. How do i group or consolidate that information to a single list of dates for each month?

    I'm guessing I need to change the way the added column in the data works but i cant seem to find anything with normal searches online.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Pivot table report filer - dates & grouping

    Perhaps get rid of the time part with an extra column with formula =INT(A1) and format as required?
    Otherwise the yellow banner on this page might get things rolling...

  3. #3
    Registered User
    Join Date
    03-23-2017
    Location
    Northern Ireland
    MS-Off Ver
    Office 2010
    Posts
    24

    Re: Pivot table report filer - dates & grouping

    That's what i couldn't figure out INT, thanks.

+ 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] Grouping Dates in Pivot Table
    By kersplash in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2018, 01:27 AM
  2. Pivot Table - Grouping dates using Report Filter
    By swaza in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-18-2015, 09:44 AM
  3. Replies: 1
    Last Post: 11-04-2014, 04:34 PM
  4. grouping dates in pivot table
    By lintcoop in forum Excel General
    Replies: 8
    Last Post: 01-09-2009, 03:29 PM
  5. [SOLVED] Grouping dates in a pivot table
    By Fred Smith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2006, 10:10 PM
  6. [SOLVED] Filer within Pivot Table
    By Rob in forum Excel General
    Replies: 2
    Last Post: 08-14-2005, 06:05 PM
  7. grouping dates in pivot table
    By Charles Maronski in forum Excel General
    Replies: 2
    Last Post: 05-21-2005, 09:06 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