View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
denhamlee denhamlee is offline
external usenet poster
 
Posts: 11
Default Pivot Table: Change dates to fiscal year

How do I change the dates in a pivot table from showing up according
to calandar year and make them show up fiscal year? My fiscal year
begins April 1st. I am wanting to choose 2006 as my year and then have
the months begin in April of 06' and end through March of 07'. Thanks