Spreadsheet: 350626d1412840582-comparing-information-on-2-different-pivot-tables-full-list-workings-in-pivot-small-
Sheet: Sheet1

CITY | SUBURB | SIZE | Average of PRICE
Auckland City | City Centre | 3 | 289000
 | City Centre Total |  | 289000
 | Mount Eden | 3 | 758266.6666666666
 |  | 2 | 594000
 | Mount Eden Total |  | 664400
 | Otahuhu | 3 | 385000
 | Otahuhu Total |  | 385000
 | Parnell | 3 | 825000
 | Parnell Total |  | 825000
Auckland City Total |  |  | 614980
Banks Peninsula | Governors Bay | 5 | 1250000
 | Governors Bay Total |  | 1250000
 | Port Levy | 4 | 1700000
 | Port Levy Total |  | 1700000
Banks Peninsula Total |  |  | 1475000
[NAME] | Karamea | 3 | 339000
 | Karamea Total |  | 339000
 | Westport | 3 | 127000
 | Westport Total |  | 127000
Buller Total |  |  | 233000
[NAME] Bay | Waipukurau | 4 | 700000
 | Waipukurau Total |  | 700000
[NAME] Bay Total |  |  | 700000
Central Otago | Clyde | 4 | 1175000
 | Clyde Total |  | 1175000
Central Otago Total |  |  | 1175000
Christchurch City | Belfast | 3 | 459000
 | Belfast Total |  | 459000
 | Halswell | 4 | 637500
 |  | 3 | 649000
 | Halswell Total |  | 641333.3333333334
Christchurch City Total |  |  | 595750
Dunedin | [NAME] | 4 | 499000
 | [NAME] |  | 499000
 | Ocean Grove | 4 | 299000
 | Ocean Grove Total |  | 299000
 | [NAME] | 2 | 159000
 | [NAME] |  | 159000
Dunedin Total |  |  | 319000
Far North | Opua | 3 | 1050000
 | Opua Total |  | 1050000
Far North Total |  |  | 1050000
Grey | Greymouth | 4 | 460000
 | Greymouth Total |  | 460000
 | Runanga | 3 | 185000
 | Runanga Total |  | 185000
Grey Total |  |  | 322500
Hauraki | Paeroa | 5 | 678500
 | Paeroa Total |  | 678500
Hauraki Total |  |  | 678500
Horowhenua | [NAME] | 3 | 409000
 | [NAME] |  | 409000
Horowhenua Total |  |  | 409000
Invercargill | Avenal | 3 | 175000
 | Avenal Total |  | 175000
Invercargill Total |  |  | 175000
[NAME] | [NAME] | 4 | 329000
 | Maungaturoto Total |  | 329000
Kaipara Total |  |  | 329000
Lower Hutt | Naenae | 3 | 209000
 | Naenae Total |  | 209000
 | Petone | 3 | 536625
 | Petone Total |  | 536625
Lower Hutt Total |  |  | 471100
Manukau City | Beachlands | 5 | 1077750
 | Beachlands Total |  | 1077750
Manukau City Total |  |  | 1077750
New Plymouth | Moturoa | 3 | 430000
 | Moturoa Total |  | 430000
New Plymouth Total |  |  | 430000
Otorohanga | Otorohanga | 4 | 523500
 | Otorohanga Total |  | 523500
Otorohanga Total |  |  | 523500
Papakura | Papakura | 3 | 349000
 | Papakura Total |  | 349000
 | Takanini | 3 | 499000
 | Takanini Total |  | 499000
Papakura Total |  |  | 424000
[NAME] | Muriwai Valley | 4 | 929000
 | Muriwai Valley Total |  | 929000
Rodney Total |  |  | 929000
Rotorua | Lake Tarawera | 5 | 1150000
 | Lake Tarawera Total |  | 1150000
Rotorua Total |  |  | 1150000
South Waikato | Putaruru | 4 | 385000
 | Putaruru Total |  | 385000
South Waikato Total |  |  | 385000
Southland | Wyndham | 3 | 170200
 | Wyndham Total |  | 170200
Southland Total |  |  | 170200
Tararua | [NAME] | 4 | 305000
 | Dannevirke Total |  | 305000
Tararua Total |  |  | 305000
Tasman | Murchison | 3 | 210000
 | Murchison Total |  | 210000
Tasman Total |  |  | 210000
[NAME] | Nukuhau | 3 | 375000
 | Nukuhau Total |  | 375000
Taupo Total |  |  | 375000
Tauranga | Mount Maunganui | 5 | 950000
 | Mount Maunganui Total |  | 950000
Tauranga Total |  |  | 950000
Thames-Coromandel | Coromandel | 2 | 425000
 | Coromandel Total |  | 425000
 | Whitianga | 3 | 660000
 | [NAME] |  | 660000
Thames-Coromandel Total |  |  | 542500
Waikato | [NAME] | 5 | 695000
 | [NAME] |  | 695000
 | [NAME] | 5 | 500000
 | Te Kauwhata Total |  | 500000
Waikato Total |  |  | 597500
Waimakariri | Ohoka | 5 | 895000
 | Ohoka Total |  | 895000
 | Oxford | 4 | 464000
 | Oxford Total |  | 464000
Waimakariri Total |  |  | 679500
Waipa | Te Awamutu | 3 | 331500
 | Te Awamutu Total |  | 331500
Waipa Total |  |  | 331500
Wairoa | Wairoa | 3 | 99000
 | Wairoa Total |  | 99000
Wairoa Total |  |  | 99000
Wellington | Melrose | 4 | 785000
 | Melrose Total |  | 785000
Wellington Total |  |  | 785000
Whakatane | Whakatane | 3 | 365000
 | Whakatane Total |  | 365000
Whakatane Total |  |  | 365000
Whangarei | Kauri | 3 | 700000
 | Kauri Total |  | 700000
 | Kensington | 3 | 355000
 | Kensington Total |  | 355000
 | One Tree Point | 4 | 495000
 | One Tree Point Total |  | 495000
Whangarei Total |  |  | 516666.6666666667
Grand Total |  |  | 560988.4615384615