Re: Would u help me with a Biggest Movers type of comparison?
- From: "Ken Wright" <ken.wright@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 20 Jan 2006 00:20:52 -0000
Apologies, just realised you wanted the biggest changes as opposed to the
biggest sales over that period.
Regards
Ken...................
"Ken Wright" <ken.wright@xxxxxxxxxxxxxxxxxx> wrote in message
news:%232EhqUVHGHA.312@xxxxxxxxxxxxxxxxxxxxxxx
> 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" <skuba.21wk6z_1137708903.6477@xxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:skuba.21wk6z_1137708903.6477@xxxxxxxxxxxxxxxxxxxxxxxx
>>
>> 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?action=getinfo&userid=6696
>> View this thread:
>> http://www.excelforum.com/showthread.php?threadid=503110
>>
>
>
.
- Follow-Ups:
- References:
- Would u help me with a Biggest Movers type of comparison?
- From: skuba
- Re: Would u help me with a Biggest Movers type of comparison?
- From: Ken Wright
- Would u help me with a Biggest Movers type of comparison?
- Prev by Date: Re: template for document control/ register as used by architects etc
- Next by Date: Re: Dates in IF statements
- Previous by thread: Re: Would u help me with a Biggest Movers type of comparison?
- Next by thread: Re: Would u help me with a Biggest Movers type of comparison?
- Index(es):
Relevant Pages
|
