Hi I would like get weighted average margin by category.
I want to use the sales to weight the margins.
Any help? thanking in advance
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
I want to use the sales to weight the margins.
Any help? thanking in advance
A | B | C | D | |
1 | Invoice Number | Product | Sales | Margin |
2 | 22 | Pen | 110 | 15% |
3 | 28 | Books | 200 | 11% |
4 | 26 | Rubber | 220 | 25% |
5 | 32 | Ink | 125 | 65% |
6 | 152 | Pen | 225 | 48% |
7 | 225 | Books | 451 | 54% |
8 | 365 | Rubber | 225 | 22% |
9 | 445 | Ink | 145 | 15% |
10 | 224 | Pen | 36 | 48% |
11 | 257 | Books | 45 | 65% |
12 | 45 | Rubber | 889 | 33% |
13 | 6987 | Ink | 54 | 5% |
14 | ||||
15 | Weighted Average Margin | |||
16 | Pen | ? | ||
17 | Books | ? | ||
18 | Rubber | ? | ||
19 | Ink | ? |
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>