[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Ross, Alexia, S,13231 | 247.90 | 0.00 | 0.00 | 104.97 | 142.93 |
| White, Edward, J,15847 | 205.46 | 0.00 | 0.00 | 119.98 | 85.48 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 751.34 | 2304.98 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 623.78 | 487.58 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 790.61 | 515.05 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 229.70 | 637.11 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
| Roberts, Noah, S,27042 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 1000.44 | 0.00 | 565.47 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 2374.98 | 2438.06 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 244.70 | 390.14 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 637.86 | 518.04 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 4814.04 | 0.00 |
Generated 2026-07-22 22:13:04.210 UTC