[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 531 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wright, Kaitlyn, G,13434 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Flores, Emily,13206 | 163.19 | 0.00 | 0.00 | 69.97 | 93.22 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Carter, Luis, E,25883 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Torres, Christina, M,20746 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| James, Bryce,13466 | 133.45 | 0.00 | 0.00 | 0.00 | 133.45 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 75.48 | 333.64 |
| Rivera, Hailey, R,20792 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Edwards, Amber, B,20517 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| James, Richard, D,15760 | 109.23 | 0.00 | 0.00 | 3.99 | 105.24 |
| Van, Bobby,27757 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
Generated 2025-11-04 14:59:03.150 UTC