Group qtr's in pivottables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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