Sort Data

  • Thread starter Thread starter valerie
  • Start date Start date
V

valerie

Hi,
I need help in sorting data.
I need to sort the records under the Units Sold and Commission in
descending order of Vehicle Type.
Units Sold:
Car 3 0 2 0 0
Van 2 3 0 4 1
Lorry 1 0 5 3 2
Commission:
Car $9,000 $0 $6,000 $0 $0
Van $16,000 $24,000 $0 $32,000 $8,000
Lorry $7,500 $0 $37,500 $22,500 $15,000
But I encountered problems sorting as theres isnt Commission listed in
the Then By column.
Thanks for any help.
 
This is the exact data;
Particulars of Salesmen:
Name Jollie Benson Zapeth Kim Marion
D-Code 4BC MBA 4BC 4BC MBA

Date:
Joined 23/04/00 12/05/00 02/09/00 31/07/00 01/07/00
Year-End 31/12/00
Days served 19 113 120 33 30

Units Sold:
Car 3 0 2 0 0
Van 2 3 0 4 1
Lorry 1 0 5 3 2
Commission:
Car $9,000 $0 $6,000 $0 $0
Van $16,000 $24,000 $0 $32,000 $8,000
Lorry $7,500 $0 $37,500 $22,500 $15,000
 
Back
Top