+ Reply to Thread
Results 1 to 2 of 2

How to group a date field into months in a pivot table

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    How to group a date field into months in a pivot table

    Hello. I have a pivot table with a column that has data values by day and time so if I try to put it on the column it won't do it as it's too many values.

    I created a month column in the actual data set but is there a way of doing this in the pivot table vs. creating new fields in the data set?

    Thanks

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

    Re: How to group a date field into months in a pivot table

    You can group by months also with a PT.
    See https://www.contextures.com/xlPivot07.html

+ 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. Group by date and create new field in Pivot Table
    By Smally in forum Excel General
    Replies: 2
    Last Post: 08-10-2015, 07:55 AM
  2. Group Field not available in Pivot Table - why?
    By govcam in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-09-2014, 01:50 PM
  3. Replies: 1
    Last Post: 01-18-2013, 03:06 PM
  4. Replies: 5
    Last Post: 12-18-2012, 11:37 AM
  5. Pivot Table - Group Individual Dates Into Months
    By Kolin in forum Excel General
    Replies: 0
    Last Post: 07-15-2010, 11:02 AM
  6. Pivot Table Group by one field but sum another
    By mma40 in forum Excel General
    Replies: 3
    Last Post: 04-07-2006, 09:55 AM
  7. Pivot table will not group a date field
    By Mary in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 10: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