[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 2407.04 | 0.00 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 66.53 | 0.00 |
| Hill, Haley, J,16103 | 3142.32 | 0.00 | 0.00 | 792.34 | 2349.98 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 187.25 | 34.98 |
| Li, Jordan,17026 | 261.39 | 0.00 | 0.00 | 261.39 | 0.00 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Walker, Ian,16771 | 104.55 | 0.00 | 0.00 | 54.58 | 49.97 |
| Yang, Jordan, K,14458 | 133.95 | 0.00 | 0.00 | 0.00 | 133.95 |
| Adams, Connor,21423 | 2888.56 | 0.00 | 0.00 | 2049.10 | 839.46 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 155.23 | 153.43 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 56.97 | 84.86 |
| Sanders, Zoe, L,24825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Luo, Jodi,29213 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Young, Courtney,17622 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Umeda, Masaki,16717 | 233.81 | 0.00 | 0.00 | 159.35 | 74.46 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 4719.02 | 0.00 |
| Phillips, Mackenzie,12444 | 228.43 | 0.00 | 0.00 | 228.43 | 0.00 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 480.17 | 910.38 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 839.29 | 316.23 |
| Hayes, Logan, J,19026 | 113.24 | 0.00 | 0.00 | 37.27 | 75.97 |
| Gonzales, Cameron, L,29005 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 51.46 | 0.00 |
| Stewart, Destiny,13144 | 281.47 | 0.00 | 0.00 | 236.23 | 45.24 |
| Alexander, Taylor,17482 | 146.94 | 0.00 | 0.00 | 76.97 | 69.97 |
| Alexander, Julian,13217 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 139.96 | 168.01 |
| Flores, Emma, P,15543 | 180.94 | 0.00 | 0.00 | 78.98 | 101.96 |
| Gonzales, Ryan, M,17373 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Foster, Carson, L,16959 | 135.35 | 0.00 | 0.00 | 120.37 | 14.98 |
Generated 2026-07-22 18:49:16.979 UTC