Pivot Table Help

[Doug]

I need help building a Pivot Table that will compare sales
by salesman by month and compare it to previous 10 years'
worth of monthly data. I have data for the last 10 years
and need to show current month and year-to-date sales
compared to the previous 10 year's sales and YTD
information. I have the following information in an Excel
spreadsheet:

SALESMAN (col A)
MONTH (col B)
SALES (col C)

How can this be accomplished?

 

[Ken Wright]

How is your monthly data recorded. Is it month/year or just a month eg Jan. Assuming you can
list all your 10 years of data in these four Columns:-

A B C D
Salesman Month Year Sales
aa Jan 1999 1213
bb Nov 2001 2345
cc Aug 2000 1345
dd Mar 2000 2347
cc Apr 2001 1345
dd Aug 2002 5643
aa Dec 2002 3456
etc..............

You should be able to select all the data, create a pivot table and drag salesman to the left,
year to the top and sales into the data field. If you want the extra detail you can also drag the
month field to the left, just to the right of the salesman field.

I've sent you a small example file to show you what I mean.