Pivot Table - Quarterly report

G

Guest

Hi,

I know Pivot Table has a function that sorts data on the quarterly basis.
If I want it to sort by the company's fiscal year (ie, May 1st to July 31st,
instead of april 1st to june 30th), can pivot table be sorted in that way?
Thanks
 
G

Guest

There is nothing built in that will do that for you. You will need to include
some indication of your periods in the source data. For instance have a
Month, Quarter and Year field right in your source data...
 

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

How do I set a pivot table to group quarterly reports by F/Y? 2
How do I replace/select new fields in pivot table using a macro? 1
Pivot Table 1
Pivot Table Date Groups 2
Pivot Table file size 4
sorting sub groups in pivot tables 1
Sort pivot table 2
Sort pivot table field (droplist) by month or original data 1

Top