1 | Result | Formula |
|---|---|---|
2 | 192 | =GETPIVOTDATA("SUM of number of units", 'Pivot Table'!A1) |
3 | $9.75 | =GETPIVOTDATA("AVERAGE of price per unit", 'Pivot Table'!A1, "division", "east") |
4 | $10.00 | =GETPIVOTDATA("price per unit", 'Pivot Table'!B4, "division", "west", "subdivision", 1) |