DATE ORDER FOR QTR 1 -4

D

DJRHUTCH

I new to pivot tables. I'm using a financial year which starts from April and
ends at March, how do can I change the pivot table to read from these months.
Currently it defaults from Jan to Dec. I'm using Office 2003.
Thanks
 
R

Roger Govier

Hi

Dave has given you what is the best solution - using an extra column in your
source data.
You could, however, do it within the PT.
First, Group by Months, not Quarters.
Then, with Months as a Row field, select the 3 months representing your Q1,
by holding down Control and clicking on each cell.
Right click>Group>name the resulting Group1 as FY2009-Q1
Repeat process allocating the other 9 months to their respective quarters.

--
Regards
Roger Govier

DJRHUTCH said:
Dave thanks very much for your help. It works for me.
Click to expand...
 
D

Dave Peterson

And continue doing this for each FY <vbg>.

Roger said:
Hi

Dave has given you what is the best solution - using an extra column in your
source data.
You could, however, do it within the PT.
First, Group by Months, not Quarters.
Then, with Months as a Row field, select the 3 months representing your Q1,
by holding down Control and clicking on each cell.
Right click>Group>name the resulting Group1 as FY2009-Q1
Repeat process allocating the other 9 months to their respective quarters.
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

Pivot Table - Finanical information by Period as a month 1
Pivot Table - month groups 2
Quarterly Data in Pivot Table 3
Group Excel data in varying length financial periods 4/5 weeks 2
Pivot Table and Grouping Problem 3
Display Pivot table summary in order of increasing time frame 4
Format Date Filter Problem 1
Calculating total amount in a Pivot Table 1

Top