how do I change order of quarters in pivot table in Excel

G

Guest

In my data fiscal year starts from 1st April and ends on 31st March. When I
generate Pivot Table and group the date by quarters the first quarter starts
from 01st Jan and not from 01st April. I want pivto table to present 1st
quarter starting from 01st April.
 
N

Nick Hodge

Kishore

This is not possible in Excel. All you can do is set up an index in a
helper column in the originating datasource of month 1, month 2, etc and
group on that. You could also subtract three months from all dates in the
helper column and use that to group quarters on (If that makes sense)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

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

Quarterly Data in Pivot Table 3
Change Quarters in Pivot Tables when grouping dates 1
quarterly reports in Access 1
Pivot Table - Quarterly report 1
Pivot Table Grouping by Quarters 3
DATE ORDER FOR QTR 1 -4 5
Pivot Table: Change dates to fiscal year 1
How do I set a pivot table to group quarterly reports by F/Y? 2

Top