[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 14 > < TAKE 8 >
8 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhao, Karen, L,25408 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Harris, Natalie,23682 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Williams, Destiny, S,15881 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| White, Emma, N,16090 | 604.96 | 0.00 | 0.00 | 0.00 | 604.96 |
| Coleman, Jose, S,25349 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bennett, Brittany, J,22332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bailey, Lauren,15864 | 103.55 | 0.00 | 0.00 | 0.00 | 103.55 |
Generated 2025-12-23 09:36:50.225 UTC