GETPIVOTDATA : Pivot Table
1
SUM of number of units
AVERAGE of price per unit
2
east
1
24
$9.50
3
2
24
$12.00
4
3
28
$8.50
5
4
23
$9.00
6
east Total
99
$9.75
7
west
1
23
$10.00
8
2
36
$9.50
9
3
34
$12.00
10
west Total
93
$10.50
11
Grand Total
192
$10.07