Pivot Table Year to Date
Jim,
I think an easy way would be to add a column with formulas that include your
criteria for how you define YTD, returning (perhaps) which YTD group it
should (or shouldn't) be included in.
HTH,
Bernie
MS Excel MVP
"Jim Thomlinson" wrote in message
...
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
|