Spreadsheet: 852865d1702861109-aggregate-function-not-working-with-filter-function-acquisition-channel-report-v2
Sheet: Buyer

 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Total Purch |  | [NAME] $ | Avg Days | [NAME] | [NAME]
 | Instant Offer Program | Results |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Retail
 | Dealer | Purchase Date | Acquisition Channel | Vehicle | [NAME] | Stocknumber | Purchase Price (inc GST) | Buyer | [NAME] | Wholesale/ Retail | Date Disposed | Sale Price (inc GST, exc DAC) | Profit/ Loss (after IO Fee & Recon) | Recon | Recon excl. [NAME] | Days to sell |  | Wholesale
 |  |  | Facebook | 2013 Renualt Clio | 6990B | 2869 | 7600 | [NAME] |  |  |  |  |  |  |  |  |  |  | Acq Channels | Buyer
 |  | 2023-06-05 00:00:00 | Carsales | 2022 Mazda cx-30 | BXF242 | 2892 | 33300 | [NAME] |  |  |  |  |  |  |  |  |  |  | IBO | MS
 |  | 2023-06-05 00:00:00 | Carsales | 2021 Nissan Qashqai | 1SY5RU | 2895 | 29300 | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  | 2023-06-05 00:00:00 | Carsales | 2019 Mitsubishi ASX | 1QT2PB | 2897 | 22500 | [NAME] |  |  |  |  |  |  |  |  |  |  | Walk In | Travis
 |  | 2023-06-09 00:00:00 | Carsales | 2016 Holden Trax | UNREG | 2941 | 12500 | [NAME] |  |  |  |  |  |  |  |  |  |  | Carsales | JK
 |  | 2023-06-09 00:00:00 | Carsales | 2021 Nissan X trail | 1TL4YM | 2943 | 26500 | [NAME] |  |  |  |  |  |  |  |  |  |  | Facebook | Mark
 |  | 2023-06-14 00:00:00 | Referral | 2017 Nissan Xtrail | EDD77D | 2958 | 16000 | [NAME] |  |  |  |  |  |  |  |  |  |  | Gumtree | [NAME]
 |  | 2023-06-14 00:00:00 | Carsales | 2016 Hyundai Tucson | 1II2KG | 2963 | 19500 | [NAME] |  |  |  |  |  |  |  |  |  |  | Referral | [NAME]
 |  | 2023-06-15 00:00:00 | IBO POA | 2017 Mazda cx-23 | BCX581 | 2974 | 24500 | [NAME] |  |  |  |  |  |  |  |  |  |  | CLA | Clinten
 |  | 2023-06-15 00:00:00 | Carsales | 2018 Hyundai i30 | 1ON4HG | 2978 | 25250 | [NAME] |  |  |  |  |  |  |  |  |  |  | Grays.com | Muha
 |  | 2023-06-19 00:00:00 | Carsales | 2020 Great Wall Steed | YJS59M | 2989 | 13000 | [NAME] |  |  |  |  |  |  |  |  |  |  | Manheim | [NAME]
 |  | 2023-06-20 00:00:00 | Carsales | 2016 Mazda cx-5 | 1JI6ER | 3004 | 22900 | [NAME] |  |  |  |  |  |  |  |  |  |  | Pickles | Nick
 |  | 2023-06-20 00:00:00 | Carsales | 2018 Honda CR-V | 1TA8NL | 3007 | 27500 | [NAME] |  |  |  |  |  |  |  |  |  |  | Tenders | [NAME]
 |  | 2023-06-26 00:00:00 | Carsales | 2019 Subaru Forester | 1TZ9SY | 3035 | 29250 | [NAME] |  |  |  |  |  |  |  |  |  |  | Wholesale | [NAME]
 |  | 2023-06-28 00:00:00 | IBO POA | 2018 [NAME] | ARY325 | 3051 | 16000 | [NAME] |  |  |  |  |  |  |  |  |  |  | Autosales
 |  | 2023-06-28 00:00:00 | Carsales | 2020 Renault Koleos | 1RD4TR | 3055 | 23250 | [NAME] |  |  |  |  |  |  |  |  |  |  | SG Fleet
 |  | 2023-06-29 00:00:00 | Carsales | 2017 Subaru Impreza | 1WA3PB | 3067 | 17500 | [NAME] |  |  |  |  |  |  |  |  |  |  | IBO POA
 |  | 2023-07-06 00:00:00 | IBO POA | 2016 Mazda 2 | 1GY1WP | 3092 | 16000 | [NAME] |  |  |  |  |  |  |  |  |  |  | Slattery
 |  | 2023-07-11 00:00:00 | IBO POA | 2017 Volkswagen Golf | AQO538 | 3112 | 17250 | [NAME] |  |  |  |  |  |  |  |  |  |  | Ash on Demand
 |  | 2023-07-19 00:00:00 | Carsales | 2017 Honda Jazz | 1LM7CW | 3147 | 16000 | [NAME] |  |  |  |  |  |  |  |  |  |  | Avis
 |  | 2023-07-20 00:00:00 | Carsales | 2018 Volkswagen Polo | 1KB6RV | 3158 | 13500 | [NAME] |  |  |  |  |  |  |  |  |  |  | Hertz
 |  | 2023-07-24 00:00:00 | Carsales | 2021 Subaru XV | 1SZ5AT | 3178 | 30000 | [NAME] |  |  |  |  |  |  |  |  |  |  | Wade
 |  | 2023-07-26 00:00:00 | Carsales | 2018 [NAME] | AUJ525 | 3191 | 10500 | [NAME] |  |  |  |  |  |  |  |  |  |  | Splend SPV
 |  | 2023-07-27 00:00:00 | Carsales | 2014 Volkswagen Polo | 1CB5LH | 3193 | 7000 | [NAME] |  |  |  |  |  |  |  |  |  |  | Lease Plan
 |  | 2023-07-28 00:00:00 | Carsales | 2017 Renault Captour | 1JZ9DM | 3206 | 15250 | [NAME]
 |  | 2023-07-28 00:00:00 | Carsales | 2015 Mazda cx-5 | 1FO6TM | 3207 | 21000 | [NAME]
 |  | 2023-07-31 00:00:00 | Carsales | 2018 Mitsubishi Triton | 1YB3WO | 3217 | 32000 | [NAME]
 |  | 2023-08-18 00:00:00 | Carsales | 2017 Subaru XV | AZG952 | 3284 | 29500 | [NAME]
 |  | 2023-08-18 00:00:00 | Carsales | 2018 Mazda 3 | 1PZ2BQ | 3283 | 21250 | [NAME]
 |  | 2023-08-26 00:00:00 | Walk In | 2009 Mazda 6 | [NAME] | 3312 | 2200 | [NAME]
 |  | 2023-08-28 00:00:00 | Walk In | 2016 Honda Hr-v | 1HO9EC | 3315 | 18000 | [NAME]
 |  | 2023-09-01 00:00:00 | IBO POA | 2015 Toyota Corolla | 1EI2EK | 3346 | 16200 | [NAME]
 |  | 2023-09-01 00:00:00 | Carsales | 2019 Subaru XV | 1QF1WQ | 3348 | 29500 | [NAME]
 |  | 2023-09-01 00:00:00 | Facebook | 2015 Renualt Captur | AFX325 | 3349 | 8000 | [NAME]
 |  | 2023-09-07 00:00:00 | IBO POA | 2019 Subaru Forester | 1PT8BU | 3365 | 31500 | [NAME]
 |  | 2023-09-13 00:00:00 | Facebook | 2017 Mitsubishi Outlander | 1NL9SP | 3390 | 20500 | [NAME]
 |  | 2023-09-15 00:00:00 | Facebook | 2021 Kia Stonic | 1UK9RX | 3400 | 19850 | [NAME]
 |  | 2023-09-18 00:00:00 | Facebook | 2018 Mitsubishi Eclipse | CD30WH | 3416 | 20000 | [NAME]
 |  | 2023-09-18 00:00:00 | Carsales | 2019 Mitsubishi Outlander | BDK701 | 3421 | 23000 | [NAME]
 |  | 2023-09-20 00:00:00 | Carsales | 2018 Kia rio | 1OH9PT | 3430 | 19000 | [NAME]
 |  | 2023-09-20 00:00:00 | SG Fleet | 2021 Subaru Forester | 1UN5LR | 3433 | 36052.01 | [NAME]
 |  | 2023-09-21 00:00:00 | Referral | 2015 Hyundai i30 | 1FU3IT | 3449 | 13500 | [NAME]
 |  | 2023-09-21 00:00:00 | Facebook | 2017 Mitsubishi ASX | 1YF6BZ | 3450 | 18250 | [NAME]
 |  | 2023-09-25 00:00:00 | Wholesale | 2020 Toyota Corolla | 1TT6WK | 3462 | 28055 | [NAME]
 |  | 2023-09-25 00:00:00 | Referral | 2016 Ford Kluger | 1IW4KA | 3465 | 14850 | [NAME]
 |  | 2023-09-28 00:00:00 | Carsales | 2016 Mini Cooper | 1KW1GG | 3495 | 18500 | [NAME]
 |  | 2023-10-02 00:00:00 | IBO POA | 2016 Hyundai Tucson | AIB534 | 3503 | 15300 | [NAME]
 |  | 2023-10-04 00:00:00 | Walk In | 2015 [NAME] | [NAME] | 3513 | 5300 | [NAME]
 |  | 2023-10-05 00:00:00 | Carsales | 2021 Toyota Corolla | 1UC1KH | 3515 | 30000 | [NAME]
 |  | 2023-10-10 00:00:00 | Carsales | 2022 Toyota Yaris Cross | 1VH2LH | 3537 | 28400 | [NAME]
 |  | 2023-10-12 00:00:00 | IBO POA | 2013 Hyundai Veloster SR | [NAME] | 3548 | 14000 | [NAME]
 |  | 2023-10-13 00:00:00 | Carsales | 2021 mazda Cx-5 | 1SB1DP | 3556 | 32000 | [NAME]
 |  | 2023-10-16 00:00:00 | Carsales | 2018 Kia Cerato | AVD880 | 3565 | 16000 | [NAME]
 |  | 2023-10-18 00:00:00 | Carsales | 2018 [NAME] | 1MD8EV | 3591 | 28300 | [NAME]
 |  | 2023-10-23 00:00:00 | Gumtree | 2022 Kia Stonic | BYP795 | 3613 | 21500 | [NAME]
 |  | 2023-10-23 00:00:00 | Carsales | 2015 Renualt captur | 1KU7QE | 3617 | 12000 | [NAME]
 |  | 2023-10-24 00:00:00 | IBO POA | 2017 Mazda Cx-9 | ARR553 | 3627 | 32750 | [NAME]
 |  | 2023-10-26 00:00:00 | Carsales | 2018 Subaru Impreza | AVD299 | 3637 | 23000 | [NAME]
 |  | 2023-10-27 00:00:00 | Walk In | 2005 Honda Accord | TJK511 | 3644 | 1500 | [NAME]
 |  | 2023-10-30 00:00:00 | Carsales | 2019 Toyota Corolla | 1PH7UZ | 3649 | 20500 | [NAME]
 |  | 2023-10-31 00:00:00 | Carsales | 2020 [NAME] | BJD976 | 3663 | 24000 | [NAME]
 |  | 2023-11-08 00:00:00 | Facebook | 2013 Renualt Clio | 664DS2 | 3710 | 8800 | [NAME]
 |  | 2023-11-13 00:00:00 | [NAME] | 2014 Mazda Cx-5 [NAME] | 1BC3JJ | 3737 | 15400 | [NAME]
 |  | 2023-11-15 00:00:00 | [NAME] | 2016 Holden Astra R | 1KI9OT | 3756 | 13300 | [NAME]
 |  | 2023-11-16 00:00:00 | [NAME] | 2018 Toyota CHR | 1KB7TH | 3786 | 24400 | [NAME]
 |  | 2023-11-17 00:00:00 | [NAME] | 2019 Volkswagen Golf | 1PJ5PT | 3790 | 23600 | [NAME]
 |  | 2023-11-20 00:00:00 | [NAME] | 2016 [NAME] | 1ZB8FM | 3809 | 15700 | [NAME]
 |  | 2023-11-20 00:00:00 | [NAME] | 2017 Toyota Rav4 | 1KD9TK | 3791 | 21300 | [NAME]
 |  | 2023-11-21 00:00:00 | [NAME] | 2022 Citroen C5X | CAG414 | 3821 | 41000 | [NAME]
 |  | 2023-11-21 00:00:00 | [NAME] | 2018 Mazda 3 | 1OV2EM | 3831 | 19800 | [NAME]
 |  | 2023-11-21 00:00:00 | [NAME] | 2014 Mazda cx5 | 1BJ7VI | 3830 | 10700 | [NAME]
 |  | 2023-11-21 00:00:00 | [NAME] | 2012 Nissan Dualis | ZDU637 | 3832 | 10000 | [NAME]
 |  | 2023-11-22 00:00:00 | [NAME] | 2016 Hyundai Accent | 1LY6OV | 3808 | 9400 | [NAME]
 |  | 2023-11-22 00:00:00 | [NAME] | 2019 Holden Commodore | 1SU9IS | 3834 | 18300 | [NAME]
 |  | 2023-11-22 00:00:00 | [NAME] | 2013 Mercedes Benz ML250 | 1AB5RU | 3841 | 18240 | [NAME]
 |  | 2023-11-23 00:00:00 | [NAME] | 2013 Volkswagen Golf | 1AB2RM | 3848 | 15100 | [NAME]
 |  | 2023-11-23 00:00:00 | [NAME] | 2020 Mitsubishi Triton | BJG535 | 3849 | 36100 | [NAME]
 |  | 2023-11-23 00:00:00 | [NAME] | 2014 Jeep Cherokee | 1RG6BQ | 3850 | 10400 | [NAME]
 |  | 2023-11-23 00:00:00 | [NAME] | 2012 Mazda Cx-5 | ZMX270 | 3851 | 10700 | [NAME]
 |  | 2023-11-23 00:00:00 | [NAME] | 2015 Holden Commodore | 1EX1ZK | 3822 | 10200 | [NAME]
 |  | 2023-11-27 00:00:00 | [NAME] | 2018 Audi Q7 | BCL073 | 3876 | 45400 | [NAME]
 |  | 2023-11-30 00:00:00 | [NAME] | 2014 Subaru Impreza | 1BL7QK | 3917 | 12400 | [NAME]
 |  | 2023-12-04 00:00:00 | [NAME] | 2022 Renault Koleos | BYD985 | 3936 | 32600 | [NAME]
 |  | 2023-12-04 00:00:00 | [NAME] | 2016 BMW 120i | AMJ379 | 3937 | 18500 | [NAME]
 |  | 2023-12-06 00:00:00 | [NAME] | 2017 [NAME] | 1LX8YT | 3948 | 18300 | [NAME]
 |  | 2023-12-08 00:00:00 | [NAME] | 2016 Mitsubishi Lancer | 1ZF1EM | 3989 | 16000 | [NAME]
 |  | 2023-12-11 00:00:00 | [NAME] | 2015 Audi Q7 | ALK586 | 3998 | 29200 | [NAME]
 |  | 2023-12-11 00:00:00 | [NAME] | 2020 Mazda  cx-9 | BJM271 | 3990 | 35300 | [NAME]
 |  | 2023-12-13 00:00:00 | [NAME] | 2017 Hyundai Accent | 1PC9UO | 4015 | 12700 | [NAME]
 |  | 2023-12-13 00:00:00 | [NAME] | 2015 Mitsubishi Triton | 1XV8UE | 4022 | 19700 | [NAME]
 |  | 2023-12-13 00:00:00 | [NAME] | 2014 Nissan Pulsar | 1DM5OH | 4023 | 7400 | [NAME]
 |  | 2023-12-14 00:00:00 | [NAME] | 2014 Mazda 3 | 1CE8TW | 4035 | 13300 | [NAME]
 |  | 2023-12-15 00:00:00 | [NAME] | 2018 Nissan Pathfinder | 1ZF1YP | 4043 | 22300 | [NAME]