Showing data per month & year for comparison

[Guest]

Hi, I need to show data for a particular month for 2 years (July 2004 vs.
July 2005) and YTD data for 2004 & 2005 on the same pivot table. This will
allow comparison between 2 months and YTD sales on the PT.

I have grouped the dates and put them along the top of the pivot table and
can choose month and year, but the YTD figures always change to the month
figures. How do I get the YTD figures to not change when I choose a month?
Confusing...yes.

 

[roly]

Hi,

Can you upload a watered down version of the spreadsheet, because it is
difficult to work out what the problem is?

I will try my best,


Roly

 

[Guest]

Sure, I'll do that on Tuesday. It's a tough problem for me; I end up copying
the pivot table, pasting it w/o the formulas and hiding the columns I don't
want. I'd like to be able to filter the data to show only the 2 months I'm
interested in w/o losing the Year to Date figures. Thanks for the response
and I look forward to hearing from you.

 

[Guest]

Hey roly, how do I upload the data?
--
gman

Sure, I'll do that on Tuesday. It's a tough problem for me; I end up copying
the pivot table, pasting it w/o the formulas and hiding the columns I don't
want. I'd like to be able to filter the data to show only the 2 months I'm
interested in w/o losing the Year to Date figures. Thanks for the response
and I look forward to hearing from you.