Group qtr's in pivottables
 

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

Group qtr's in pivottables
 

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

Group qtr's in pivottables
 

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