Define fiscal year

  • Thread starter Thread starter TeeLt
  • Start date Start date
T

TeeLt

how to define fiscal year when it is not the calender year (Jan-Dec).
Example I need the fiscal year to be Oct-Sept. When I preapre a pivot table,
I need the 1st quarter to be Oct-Dec in the group option
 
Hi,

Hope this help, try to format the date as Oct-08, Nov-08 etc...Sept-09

and the pivot table will works.

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"TeeLt" escreveu:
 
I would add an extra column to the table where you calculate the fiscal
quarter (or fiscal month). Then summarize on that.

Regards,
Fred.
 
Back
Top