LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default Grouping dates in PT; need last 6 month data

Am trying to group data that falls within the past 6 months.
Source data date ranges include dates from 1/1/1900 to 12/08/2008.
The grouping dialogue box allows me to select a number of days, and I
set to 190 days.
The begin range, I set to start 6/01/2008, and ending today.
The PT results still include breakouts such as:
2/28/2008 - 9/4/2008
9/5/2008 - 12/9/2008

What are the chances for a single breakout of the events that happen
within the 6 month range?

TIA for ideas.

Pierre
(For some strange reason, the start date, will usually migrate back to
01/01/1900, and I have to start all over again.)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping by month in a Pivot Table John Excel Discussion (Misc queries) 1 October 7th 08 10:08 AM
Grouping Dates bluesifi Excel Discussion (Misc queries) 3 May 9th 08 11:02 PM
Grouping totals together by month per customer Mike Koop Excel Discussion (Misc queries) 6 September 18th 07 09:40 PM
Grouping Date By Month Andy Graham Excel Discussion (Misc queries) 4 September 1st 05 04:07 PM
grouping dates by week/month/etc. on cat. axis Kamal Hood Charts and Charting in Excel 4 January 23rd 05 10:06 AM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"