Spreadsheet: 88407d1288229052-pivot-dividing-by-count-of-text-in-calculated-field-query
Sheet: DATA

AREA | CHANNEL | Outlet Code | CUSTOMER | CLASS | Asset | ASSET TYPE | Serial Number | SALES
DCM 2 | ENTERTAINMENT AND LE | 64267200 | VIDEO CITY NEW TOWN | A | 8026729 | ASSORTED | 200911XINGX0342 | 616.35
DCM 2 | ENTERTAINMENT AND LE | 64267200 | VIDEO CITY NEW TOWN | A | 8042012 | VT 250 | 200806FRAME0049
DCM 2 | ENTERTAINMENT AND LE | 64390403 | PORT ARTHUR HISTORIC | A | 8037531 | ASSORTED | 200812XINGX0886 | 533.8
DCM 2 | ENTERTAINMENT AND LE | 64390403 | PORT ARTHUR HISTORIC | A | 8038487 | ASSORTED | 200812XINGX0817
DCM 2 | ENTERTAINMENT AND LE | 64390403 | PORT ARTHUR HISTORIC | A | 8044410 | 6 FOOT SLOPE | 320100062770537
DCM 2 | ENTERTAINMENT AND LE | 64390403 | PORT ARTHUR HISTORIC | A | 8044873 | 6 FOOT SLOPE | 320100062770984
DCM 2 | ENTERTAINMENT AND LE | 64222837 | QUESTACON SCIENCE & | A | 8036022 | 6 FOOT SLOPE | 28017800001252 | 2820.365
DCM 2 | ENTERTAINMENT AND LE | 64222837 | QUESTACON SCIENCE & | A | 8036275 | Upright Freezer | 20070365
DCM 2 | ENTERTAINMENT AND LE | 64226206 | ACTIVE LEISURE CENTR | A | 8011929 | 6 FOOT SLOPE | [PHONE] | 1527.1
DCM 2 | ENTERTAINMENT AND LE | 64251266 | NATIONAL ZOO & AQUAR | A | 8051570 | 6 FOOT SLOPE | 330600062840059 | 1742.035
DCM 2 | ENTERTAINMENT AND LE | 64251266 | NATIONAL ZOO & AQUAR | A | 8051593 | 6 FOOT SLOPE | 330600062840077
DCM 2 | ENTERTAINMENT AND LE | 64232622 | MAIN BEACH KIOSK NO. | A | 8001418 | 6 FOOT FLAT | 91353564 | 176.758333333
DCM 2 | ENTERTAINMENT AND LE | 64232622 | MAIN BEACH KIOSK NO. | A | 8001453 | 6 FOOT FLAT | 91353610
DCM 2 | ENTERTAINMENT AND LE | 64232622 | MAIN BEACH KIOSK NO. | A | 8015025 | 6 FOOT FLAT | [PHONE]
DCM 2 | ENTERTAINMENT AND LE | 64232622 | MAIN BEACH KIOSK NO. | A | 8015366 | 6 FOOT FLAT | [PHONE]
DCM 2 | ENTERTAINMENT AND LE | 64232622 | MAIN BEACH KIOSK NO. | A | 8021427 | ASSORTED | 200908XINGX0898
DCM 2 | ENTERTAINMENT AND LE | 64232622 | MAIN BEACH KIOSK NO. | A | 8037211 | 6 FOOT SLOPE | 28017800001734
DCM 2 | ENTERTAINMENT AND LE | 64232368 | FAIRY PARK P L ACN 0 | A | 8004073 | ASSORTED | 02513978 | 545.248
DCM 2 | ENTERTAINMENT AND LE | 64232368 | FAIRY PARK P L ACN 0 | A | 8015362 | 6 FOOT FLAT | [PHONE]
DCM 2 | ENTERTAINMENT AND LE | 64232368 | FAIRY PARK P L ACN 0 | A | 8024563 | ASSORTED | 200905XINGX4351
DCM 2 | ENTERTAINMENT AND LE | 64232368 | FAIRY PARK P L ACN 0 | A | 8032158 | 6 FOOT FLAT | 89441794
DCM 2 | ENTERTAINMENT AND LE | 64232368 | FAIRY PARK P L ACN 0 | A | 8037047 | 6 FOOT SLOPE | 28017800000594
DCM 2 | ENTERTAINMENT AND LE | 64233109 | REPTILE PARK KIOSK | A | 8003425 | ASSORTED | 03173251 | 388.625
DCM 2 | ENTERTAINMENT AND LE | 64233109 | REPTILE PARK KIOSK | A | 8034694 | 2 FOOT SLOPE | 002070725000192
DCM 2 | ENTERTAINMENT AND LE | 64221434 | MOGO ZOO | A | 8000432 | ASSORTED | 89272172 | 1236.46
DCM 2 | ENTERTAINMENT AND LE | 64221434 | MOGO ZOO | A | 8007129 | VT 200 | [PHONE]
DCM 2 | ENTERTAINMENT AND LE | 64221580 | SHOALHAVEN CITY COUN | A | 8015537 | ASSORTED | [PHONE] | 1351.69
DCM 2 | ENTERTAINMENT AND LE | 64252711 | MOLLYMOOK BEACH HUT | A | 8023691 | ASSORTED | 200812XINGX1755 | 3298.58
DCM 2 | ENTERTAINMENT AND LE | 64265157 | BAY LEISURE CENTRE | A | 8024846 | ASSORTED | 200905XINGX3088 | 680.35
DCM 2 | ENTERTAINMENT AND LE | 64265157 | BAY LEISURE CENTRE | A | 8047055 | ASSORTED | E04876