[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 31 > TITLE Top 1000 Australian Internet customers for 2020
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 77.77 | 769.00 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 34.99 | 599.85 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Ward, Jade, D,14661 | 195.02 | 0.00 | 0.00 | 0.00 | 195.02 |
| Roberts, Amber, W,21582 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Ross, Alexia, S,13231 | 247.90 | 0.00 | 0.00 | 0.00 | 247.90 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 0.00 | 2049.10 | 1145.48 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Rivera, Caitlin, L,26113 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Adams, Connor,21423 | 2888.56 | 0.00 | 0.00 | 2049.10 | 839.46 |
| Ward, Juan, H,21595 | 2649.56 | 0.00 | 0.00 | 2049.10 | 600.46 |
| Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Hayes, Carson, A,12447 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 137.45 | 565.54 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Lal, Robert, L,14084 | 138.68 | 0.00 | 0.00 | 0.00 | 138.68 |
| Bell, Danielle,14041 | 4765.02 | 0.00 | 0.00 | 0.00 | 4765.02 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 213.86 | 911.50 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Richard, L,27406 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Ward, Stephanie, A,27429 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
Generated 2025-11-06 05:23:43.919 UTC