Pivot Table - Quarterly report
 

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

Pivot Table - Quarterly report
 

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...
--
HTH...

Jim Thomlinson


"SA" wrote:

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