[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Roberts, Amber, W,21582 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Perez, Sydney, C,22117 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Robinson, Julia,28121 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Zukowski, Jake,22058 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Russell, Xavier,12964 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
Generated 2025-12-21 02:43:33.262 UTC