Hi Dave
I thought as much - what a pain! Many thanks for your response.

johnb

"Dave Peterson" wrote:

I don't think you can change the way the pivottable groups by quarter.

Maybe you could add another column in your raw data that determines the fiscal
year/quarter. Then do your pivottable based on that.



johnb wrote:

Hi All

How do I change a pivottables group by qtr1 which starts at the start of the
year to start at say 6th April and have qtr1 label start at the same date?

TIA
johnb

--

Dave Peterson