ExcelBanter - View Single Post - Would u help me with a Biggest Movers type of comparison?

Might want to consider a pivot table. Assuming your data is in database
format, and from the sound of it it is, add a month column if you don't
already have one, and label each block of data with the right month, such
that if your block of data was in say A2:D100, then in E2:E100 you put
Jan-06, and with your second block of data underneath in say A101:D220, in
E101:E220 put Feb-06. Give the column a header and call it month.

Select all your data and do Data / Pivot table and PivotChart report, then
hit next / next / finish.

Drag your salesman ID field into the ROW areas and then drag the Sales field
into the DATA field. Lastly drag the Month field into the COLUMN area.

You will now have a table of values, and to sort by sales amount, click on
one of the salesman IDs, then right click and choose Field Settings /
Advanced, and then select 'Descending' in the autosort options, and 'Sum of
sales' in the 'using field' section and hit OK.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"skuba" wrote in
message ...

Hi,
It would really help my work if I could compare reports from 2
different months and have a type of biggest movers index or rank.
In these case, the numbers have to do with sales by each affiliate.
Each of them have unique ids, their sales might change from month to
month, so basically I would like to get 2 individual reports, then
excel would look into them and tell me which affiliates moved the most
up or down, selling more than previously or selling less.

Any ideas on how to get started or whats the best approach?

I appreciate your input.

Thanks

--
skuba
------------------------------------------------------------------------
skuba's Profile:
http://www.excelforum.com/member.php...fo&userid=6696
View this thread: http://www.excelforum.com/showthread...hreadid=503110