[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 85 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Miller, Chloe, V,22893 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Edwards, Madeline,20771 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Powell, Ian,26085 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
Generated 2025-12-21 16:10:48.456 UTC