Spreadsheet: 708233d1607684765-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: GLOBAL

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Area | Bundled | End user price in EUR after VAT
 | Streamer (outside sound processor) | MedEL | AudioLink | 0 | 760 | High income | EUROPE | 0 | 760
SPAIN | Streamer (outside sound processor) | MedEL | AudioLink | 0 | 657.09 | High income | EUROPE | 0 | 657.09
SPAIN | [NAME] | MedEL | DL-Coil Base | 31305 | 603.14 | High income | EUROPE | 0 | 603.14
AUSTRALIA | Recheargable battery | MedEL | Battery Standard | 0 | 900 | High income | OCEANIA | Yes | 551.4300000000001
AUSTRALIA | Recheargable battery | MedEL | Battery Micro | 0 | 900 | High income | OCEANIA | Yes | 551.4300000000001
ITALY | Charger | OM | Charger | 181544 | 549 | High income | EUROPE | 0 | 549
SPAIN | Charger | OM | Charger | 181544 | 538 | High income | EUROPE | 0 | 538
PORTUGAL | Charger | OM | Charger | 181544 | 538 | High income | EUROPE | 0 | 538
USA | Streamer (outside sound processor) | MedEL | AudioLink | 0 | 650 | High income | AMERICA | 0 | 536.705
ITALY | [NAME] | MedEL | DL-Coil Base | 31305 | 535 | High income | EUROPE | 0 | 535
NEW-ZEALAND | Recheargable battery | MedEL | Battery Standard | 0 | 900 | High income | OCEANIA | Yes | 523.35
NEW-ZEALAND | Recheargable battery | MedEL | Battery Micro | 0 | 900 | High income | OCEANIA | Yes | 523.35
ITALY | Wireless Mic | Cochlear | [NAME] 2+ | 0 | 520 | High income | EUROPE | 0 | 520
USA | Full swim kit | AB | Aquacase | 0 | 600 | High income | AMERICA | 0 | 495.42
FRANCE | Full swim kit | AB | Aquacase | 0 | 490 | High income | EUROPE | 0 | 490
CANADA | Charger | OM | Charger | 181544 | 725 | High income | AMERICA | Yes | 467.6975
AUSTRALIA | Streamer (outside sound processor) | OM | Streamer XM | 0 | 750 | High income | OCEANIA | 0 | 459.525
NEW-ZEALAND | Streamer (outside sound processor) | OM | Streamer XM | 0 | 750 | High income | OCEANIA | 0 | 436.125
USA | [NAME] | MedEL | DL-Coil Base | 31305 | 500 | High income | AMERICA | 0 | 412.85
POLAND | Charger | OM | Charger | 181544 | 1845 | High income | EUROPE | 0 | 412.173
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Area | Bundled | End user price in EUR after VAT
 | Swim sleeve kit | Cochlear | Aqua + Sleeve | ZS44583 | 2.6 | High income | AMERICA | 0 | 2.14682
RUSSIA | Antenna cable | OM | Antenna Cable 60 mm | 171291 | 300 | High income | ASIA | 0 | 3.357
RUSSIA | Antenna cable | OM | Antenna Cable 100 mm | 171292 | 300 | High income | ASIA | 0 | 3.357
RUSSIA | Antenna cable | OM | Antenna Cable 280 mm | 171293 | 300 | High income | ASIA | 0 | 3.357
RUSSIA | Antenna cable | MedEL | DL-Coil cable for connection of SONNET and DL-Coil 65 mm | 32540 | 900 | High income | ASIA | 0 | 10.071
RUSSIA | Antenna cable | MedEL | DL-Coil cable for connection  of SONNET and DL-Coil 90 mm | 32541 | 900 | High income | ASIA | 0 | 10.071
RUSSIA | Antenna cable | MedEL | DL-Coil cable for connection  of SONNET and DL-Coil 280 mm | 31580 | 900 | High income | ASIA | 0 | 10.071
CANADA | Drying kit | AB | Dry & Store Dessicant Kit | CI-7313-001  (STD) | 16 | High income | AMERICA | Yes | 10.3216
DENMARK | Recheargable battery | AB | PowerCel 110 | CI-5511-110 | 100 | High income | EUROPE | 0 | 13.43
RUSSIA | [NAME] | Cochlear | Slimline Coil | Z597489 | 1300 | High income | ASIA | 0 | 14.547
RUSSIA | [NAME] | MedEL | DL-Coil Base | 31305 | 1800 | High income | ASIA | 0 | 20.142
UK | Antenna cable | OM | Antenna Cable 40 mm | 206890 | 20.48 | High income | UK | 0 | 22.62016
UK | Antenna cable | OM | Antenna Cable 60 mm | 171291 | 20.48 | High income | UK | 0 | 22.62016
UK | Antenna cable | OM | Antenna Cable 100 mm | 171292 | 20.48 | High income | UK | 0 | 22.62016
UK | Antenna cable | OM | Antenna Cable 280 mm | 171293 | 20.48 | High income | UK | 0 | 22.62016
RUSSIA | Recheargable battery | Cochlear | Standard Rechargeable Battery Module | [NAME] | 2250 | High income | ASIA | 0 | 25.1775
RUSSIA | Recheargable battery | OM | [NAME]  rechargeable battery | 158066 | 2500 | High income | ASIA | 0 | 27.975
RUSSIA | Recheargable battery | OM | [NAME]  rechargeable battery | 158073 | 2500 | High income | ASIA | 0 | 27.975
NEW-ZEALAND | Full swim kit | MedEL | WaterWear | 0 | 55 | High income | OCEANIA | 0 | 31.9825
AUSTRALIA | Full swim kit | MedEL | WaterWear | 0 | 55 | High income | OCEANIA | 0 | 33.6985
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Area | Bundled | End user price in EUR after VAT | Average
….....