Define fiscal year

[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

 

[Marcelo]

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:

 

[Fred Smith]

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

Regards,
Fred.

 

[Herbert Seidenberg]

Pivot Table, Group, Fiscal Year, Fiscal Quarter
Here is an implementation of Fred's idea:
http://www.savefile.com/files/1671029