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

Regards,
Fred.

"TeeLt" wrote in message
...
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