Thread: How do I set a pivot table to group quarterly reports by F/Y?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Mark is offline
external usenet poster
  
Posts: 989
Default How do I set a pivot table to group quarterly reports by F/Y?
I'm trying to set up a report in Excell using the pivot table function. When
I use the "Group Field" function to generate a quarterly report it assigns
each quarter according to a calendar year which puts the Jan 2010 data in the
1st QTR and the Oct 2009 data in the 4th Quarter. I want to change this so
it begins the 1st QTR in Oct. Is there a way to change the way the pivot
table reads and organizes the data?
Reply With QuoteReply With Quote