View Single Post
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can calculate the Fiscal quarter in a new field in the source data
table, then add that field to the pivot table.

For example, with your dates in column A, insert a blank column to the
right.
Add a heading in cell B1, such as "Quarter"
Then enter the following formula in cell B2:

=YEAR(A2)+IF(MONTH(A2)=8,1,0)&"-"&CHOOSE(MONTH(A2),2,3,3,3,4,4,4,1,1,1,2,2)

Copy the formula down to the last row of data.
Refresh the pivot table, and add the new field.


fnov wrote:
Pivot Tables default to the first Quarter of a year commencing January. Is it
possible to have the first quarter commencing July, as per Finacial rather
than Calender year?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html