[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 29 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 0.00 | 4774.04 |
| Bell, Christina,26099 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Flores, Gabriel,27111 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Johnson, Anthony, D,27022 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Bell, Alex, M,16754 | 3118.60 | 0.00 | 0.00 | 0.00 | 3118.60 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Washington, Hailey, S,25885 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Blue, Paige,21703 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-22 03:16:17.301 UTC