DATE ORDER FOR QTR 1 -4

[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

 

[DJRHUTCH]

Dave thanks very much for your help. It works for me.

 

[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

Dave thanks very much for your help. It works for me.

 

[Dave Peterson]

And continue doing this for each FY <vbg>.

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.

 

[Roger Govier]

lol

I did preface it with

Dave has given you what is the best solution

Good to see the wit is still alive and well. Cheers Dave.

 

[Dave Peterson]

It's half alive! (My wit, that is!)

lol

I did preface it with

Dave has given you what is the best solution

Good to see the wit is still alive and well. Cheers Dave.