Group qtr's in pivottables

J

johnb

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
 
D

Dave Peterson

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.
 
Top