[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 15 > < TAKE 8 >
8 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Kelly, Bailey, R,28284 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Gonzalez, Chelsea, E,18103 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Chen, David,27208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-21 17:08:26.123 UTC