View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default Grouping dates in PT; need last 6 month data

Add a helper column, and assuming your dates are in column A then populate
that helper column automatically, using a formula such as

=IF(A1<DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),"Hide","Show")
copied down.

Drag that field into your page fields and filter on "Show". Then choose
whatever lower level of detail you want from the options available, eg
months etc

Regards
Ken......................


"Pierre" wrote in message
...
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.)