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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivottable Qtr's 1
Pivot Table 4
Report Wizard - Group by - Fiscal Year 2
copy/paste won't refer to the appropriate range of cells 1
Form Open 1
sum a range based on Qtr and Year 2
Reference page header to query parameters 2
Looping through Pivottables 1

Back
Top