Hi!

I have a no. of sales designs whose no. keeps varying in my database. I want to find out the Avg weight of sales of each design and compare it with the sales of that design by each individual sales person, without sorting out the data in the col.

For example, sales person A sells 20 pieces of design 4 and B sells 10, so my result should say 15 in front of col. for design 4 for both A & B

**Sample file with sample result attached**

My data is as follows:

[TABLE="width: 203"]

Sales Person

[TD="align: right"]Design no.

[/TD]

[TD="align: right"]Pieces sold

[/TD]

B

[TD="align: right"]4

[/TD]

[TD="align: right"]10

[/TD]

C

[TD="align: right"]3

[/TD]

[TD="align: right"]11

[/TD]

D

[TD="align: right"]4

[/TD]

[TD="align: right"]13

[/TD]

E

[TD="align: right"]2

[/TD]

[TD="align: right"]18

[/TD]

F

[TD="align: right"]3

[/TD]

[TD="align: right"]3

[/TD]

G

[TD="align: right"]4

[/TD]

[TD="align: right"]7

[/TD]

H

[TD="align: right"]1

[/TD]

[TD="align: right"]6

[/TD]

I

[TD="align: right"]5

[/TD]

[TD="align: right"]3

[/TD]

J

[TD="align: right"]1

[/TD]

[TD="align: right"]1

[/TD]

K

[TD="align: right"]1

[/TD]

[TD="align: right"]5

[/TD]

L

[TD="align: right"]2

[/TD]

[TD="align: right"]19

[/TD]

M

[TD="align: right"]1

[/TD]

[TD="align: right"]7

[/TD]

N

[TD="align: right"]5

[/TD]

[TD="align: right"]12

[/TD]

O

[TD="align: right"]2

[/TD]

[TD="align: right"]4

[/TD]

P

[TD="align: right"]2

[/TD]

[TD="align: right"]9

[/TD]

[/TABLE]