Is possible to custom group dates in a Pivot Table in Excel 2000. I am
familiar with the normal grouping option of months, quarters, years etc., but
have a need for grouping 3 months together that are not the 3 that form a
quarter.

I've always added another column to the raw data that did the grouping for me.

For instance, if my fiscal year started on April 1st, I'd use:
="FY"&YEAR(A1)-1+(MONTH(A1)=4)&"--Q"&INT(1+MOD(MONTH(A1)-4,12)/3)
to see:
FY2007--Q1

Then I'd just pivot on that column.


SueD wrote:

Is possible to custom group dates in a Pivot Table in Excel 2000. I am
familiar with the normal grouping option of months, quarters, years etc., but
have a need for grouping 3 months together that are not the 3 that form a
quarter.

--

Dave Peterson

Thanks - I think I just about follow it!


"Dave Peterson" wrote:

I've always added another column to the raw data that did the grouping for me.

For instance, if my fiscal year started on April 1st, I'd use:
="FY"&YEAR(A1)-1+(MONTH(A1)=4)&"--Q"&INT(1+MOD(MONTH(A1)-4,12)/3)
to see:
FY2007--Q1

Then I'd just pivot on that column.


SueD wrote:

Is possible to custom group dates in a Pivot Table in Excel 2000. I am
familiar with the normal grouping option of months, quarters, years etc., but
have a need for grouping 3 months together that are not the 3 that form a
quarter.

--

Dave Peterson