DATE ORDER FOR QTR 1 -4

  • Thread starter Thread starter DJRHUTCH
  • Start date Start date
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
 
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...
 
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

How do I set a pivot table to group quarterly reports by F/Y? 2
Countifs or a pivot 1
Pivot Table - Finanical information by Period as a month 1
4-4-5 Calendar 1
If cell = now – current Qtr – 28 days then RED 3
Pivot Table - month groups 2
Pivot Tables and Fiscal Year 2
changing year grouping in pivot table 4

Back
Top