LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Reports Year to date Values limister Excel Discussion (Misc queries) 4 April 17th 09 06:57 AM
Pivot Table by Financial Year fn450 Excel Discussion (Misc queries) 2 August 27th 08 12:50 PM
changing year grouping in pivot table Becksicle Excel Discussion (Misc queries) 4 January 21st 08 05:50 PM
Pivot table - multiple records with same year?? Don Excel Discussion (Misc queries) 1 May 9th 07 04:01 PM
Setting up "Year to Date" Calculations in a Pivot Table Project64 Excel Worksheet Functions 1 March 22nd 05 01:50 AM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"