[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 60 > TITLE Top 1000 Australian Internet customers for 2020
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Hayes, Gavin, A,19400 | 1179.47 | 0.00 | 0.00 | 1179.47 | 0.00 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 623.78 | 487.58 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 637.86 | 518.04 |
| Powell, Ian,26085 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 2351.96 | 2393.06 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 471.29 | 654.07 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 38.88 | 247.94 |
| Kelly, Bailey, R,28284 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wang, Austin, A,14632 | 84.97 | 0.00 | 0.00 | 9.99 | 74.98 |
| 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 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 488.15 | 522.41 |
| 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 |
| Stewart, Alexandria,17476 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 330.95 | 668.27 |
| 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 |
| Rodriguez, Joshua, A,23511 | 4843.11 | 0.00 | 3578.27 | 1264.84 | 0.00 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Henderson, Olivia,18859 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 144.97 | 127.72 |
| Richardson, Nathaniel,12089 | 4710.03 | 0.00 | 0.00 | 4710.03 | 0.00 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 128.95 | 31.97 |
| Smith, Andrew,14723 | 87.57 | 0.00 | 0.00 | 87.57 | 0.00 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 2367.92 | 0.00 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 44.88 | 56.97 |
| Davis, Marcus, T,17337 | 123.91 | 0.00 | 0.00 | 101.93 | 21.98 |
| Lewis, Brianna, H,14282 | 166.24 | 0.00 | 0.00 | 74.98 | 91.26 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 822.35 | 467.98 |
| Torres, Pedro, E,16958 | 168.02 | 0.00 | 0.00 | 168.02 | 0.00 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 693.99 | 412.69 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 97.81 | 29.99 |
| 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 |
| 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 |
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.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 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| 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 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 229.70 | 637.11 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 108.54 | 0.00 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 138.72 | 38.88 |
Generated 2026-07-22 22:52:57.094 UTC