Pivot Table - Quarterly report

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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...
 
Back
Top