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

K

Kishore Patel

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

Dealing with a Pivot Table (when I don't want to) 0
Quarterly Data in Pivot Table 3
DATE ORDER FOR QTR 1 -4 5
quarterly reports in Access 1
Change Quarters in Pivot Tables when grouping dates 1
number of months and days between two dates without approximation 3
How do I set a pivot table to group quarterly reports by F/Y? 2
Excel Report Cashflow Calculation 1

Top