[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 62 > TITLE Top 1000 Australian Internet customers for 2020
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.72 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 128.21 | 475.32 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 330.95 | 668.27 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 488.15 | 522.41 |
| James, Maria,16243 | 91.97 | 0.00 | 0.00 | 69.99 | 21.98 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 822.35 | 467.98 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 108.54 | 0.00 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 693.99 | 412.69 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 229.70 | 637.11 |
| Wang, Austin, A,14632 | 84.97 | 0.00 | 0.00 | 9.99 | 74.98 |
| Ramirez, Richard, C,28239 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 23.97 | 194.96 |
| Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 101.26 | 185.04 |
| Morris, Paige, W,22041 | 4167.23 | 3578.27 | 0.00 | 0.00 | 588.96 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 549.40 | 375.21 |
| Lewis, Brianna, H,14282 | 166.24 | 0.00 | 0.00 | 74.98 | 91.26 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 562.68 | 284.09 |
| Ramirez, Emma,29072 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Washington, Adam, G,25437 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Richardson, Devin, G,21318 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Wright, Katelyn, A,14502 | 122.26 | 0.00 | 0.00 | 84.97 | 37.29 |
| Allen, Sean, L,12097 | 159.22 | 0.00 | 0.00 | 126.95 | 32.27 |
| Cooper, Grace, C,16012 | 94.26 | 0.00 | 0.00 | 94.26 | 0.00 |
| Gonzalez, Logan, J,17483 | 64.50 | 0.00 | 0.00 | 64.50 | 0.00 |
| Patterson, Aaron, W,19113 | 1184.46 | 0.00 | 0.00 | 1184.46 | 0.00 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 138.72 | 38.88 |
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 548.98 | 0.00 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 84.96 | 70.95 |
| Perry, Jennifer, J,22120 | 5962.34 | 3578.27 | 0.00 | 2384.07 | 0.00 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 4814.04 | 0.00 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Kumar, Elijah,15197 | 156.92 | 0.00 | 0.00 | 49.97 | 106.95 |
| Kapoor, Preston,21431 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Stewart, Alexandria,17476 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 307.78 | 453.15 |
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 156.27 | 263.20 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 2351.96 | 2393.06 |
| Hall, Jose, J,17601 | 225.42 | 0.00 | 0.00 | 225.42 | 0.00 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 145.48 | 69.97 |
| Foster, Caleb,27112 | 114.46 | 0.00 | 0.00 | 114.46 | 0.00 |
| Sanchez, Shelby,16021 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Davis, Marcus, T,17337 | 123.91 | 0.00 | 0.00 | 101.93 | 21.98 |
| Torres, Pedro, E,16958 | 168.02 | 0.00 | 0.00 | 168.02 | 0.00 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 623.78 | 487.58 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 471.29 | 654.07 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 97.81 | 29.99 |
| Coleman, Isabel, S,12530 | 337.90 | 0.00 | 0.00 | 262.92 | 74.98 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 848.47 | 0.00 |
| Adams, Gabriel, S,19527 | 1219.45 | 0.00 | 0.00 | 1219.45 | 0.00 |
| Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 224.92 | 62.28 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 144.97 | 127.72 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 116.91 | 97.35 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 99.53 | 71.94 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 36.96 | 121.55 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 44.88 | 56.97 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
Generated 2026-07-22 22:50:46.360 UTC