[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 984 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alvarez, Melody,25070 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Scott, Mason,23551 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanchez, Jeremiah, E,22265 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Stewart, Makayla,16649 | 115.94 | 0.00 | 0.00 | 0.00 | 115.94 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Stewart, Marcus, R,20632 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Edwards, Elijah, D,28157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ortega, Sheila, M,27632 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Melissa,25173 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Alexander, Angelica,22714 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Luo, Donna, E,24805 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-24 06:15:56.400 UTC