Change Quarters in Pivot Tables when grouping dates

G

Guest

I have a list of business transactions with the daily date for each
transaction. I use Pivot Tables to track a lot of different information. I
use the group feature in Pivot Tables to group the dates by Month and
Quarter. This is a terrific option.

Here is my question:
1) Can I change the Quarter to my company's quarters? Our first quarter is
May-July, second quarter is August-Oct, third quarter is Nov-Jan, and fourth
quarter is Feb-April.

If this is possible, I would greatly appreciate any suggestions.
Thanks!
Jugglertwo
 
D

Dave Peterson

I don't think so.

I always add another column and add a formula that returns the FY-Q.

I like this expression since I can sort it easily:
="FY"&YEAR(A2)-(MONTH(A2)<5)&"-Q"&INT(1+MOD(MONTH(A2)-5,12)/3)

And then I include that extra field in my pivottable.
 

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

Change quarters in Pivot table when grouping 1
Pivot Table Grouping by Quarters 3
Custom grouping in Pivot Tables 2
How do I set a pivot table to group quarterly reports by F/Y? 2
Pivot Tables and Fiscal Year 2
Setting quarter dates in excel 5
Grouping dates in pivot table by quarters 4
calculating number of three month periods between two dates... 3

Top