Custom grouping in Pivot Tables

S

SueD

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

Dave Peterson

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

SueD

Thanks - I think I just about follow it!


Dave Peterson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
Pivot Tables and Fiscal Year 2
Change quarters in Pivot table when grouping 1
pivot table data 2
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Groupings Fail if 1of the items isn't in the next data 1
Grouping by month in a Pivot Table 1
Pivot table grouping help 0

Top