+ Reply to Thread
Results 1 to 4 of 4

Group data for the last twelve months.

  1. #1
    Registered User
    Join Date
    05-24-2018
    Location
    Canada
    MS-Off Ver
    Windows 7
    Posts
    35

    Group data for the last twelve months.

    i have 4 years of data and would like to select the last twelve months.
    Steps ive taken so far:
    -Turn my data into a table
    -I created a pivot table using the table i just created
    -Right Clicked on a date cell of the pivot table and chose group.
    -Start date is twelve months ago and End date, today. By: Months.
    -Dates showing (jan - dec) although the start date was in june...

    Not sure whats happening there.

    Thank you!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Group data for the last twelve months.

    Add grouping by year (to have two grouping factors active: month and year)
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    05-24-2018
    Location
    Canada
    MS-Off Ver
    Windows 7
    Posts
    35

    Re: Group data for the last twelve months.

    exactly what i needed thank you!

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Group data for the last twelve months.

    Glad it worked for you, and thanks for the reputation :-)

+ 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] Copy down a formula twelve months then adjust for the next twelve
    By her.rockstar in forum Excel General
    Replies: 10
    Last Post: 03-23-2018, 11:54 AM
  2. [SOLVED] Return previous twelve months from today
    By rs1aj in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-05-2014, 03:53 PM
  3. formulas for trailing twelve months (two rounds)
    By ammartino44 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-31-2013, 01:35 PM
  4. trailing twelve months formula
    By amartino44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2013, 02:28 PM
  5. ratio formulas for last twelve months
    By amartino44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2013, 02:37 PM
  6. Trailing twelve months pivot chart with calculations
    By Neoflash in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-18-2013, 10:17 PM
  7. Excel 2007 : last twelve months total rolling
    By swifty1 in forum Excel General
    Replies: 5
    Last Post: 04-19-2013, 03:28 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