View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Pivot Table Year to Date

I am creating a report using a pivot table and I am stuck trying to come up
with Year to Date balances. The report needs to show the following headings...

Nov 2004 YTD Nov 2004 Nov 2003 YTD Nov 2003
Sales

The dates are stored in Excel date format and they are grouped to give me
the years and the months. So the month Totals are easy but I am stuck on the
Year To Date...

--
Thanks In Advance...

Jim Thomlinson