View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Grouping dates in PT; need last 6 month data

Hi,

It groups just fine for me.

I set the Start date at 6/1/08 and left the End Date alone.
I entered 182 or 183 in the number of days box, and took off all other
options Months, Years,.... Finally, I opened the Date filter and turner off
all of the dates except 6/1/08 - 11/30/08.

What version of Excel are you using?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Pierre" wrote:

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.)