Custom grouping in Pivot Tables
 

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.

Custom grouping in Pivot Tables
 

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

Custom grouping in Pivot Tables
 

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