[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 204 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hall, Julia, L,18074 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Kapoor, Francisco, M,16063 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Thomas, Blake, D,29242 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| Hayes, Jose, M,15512 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Hu, Laura,29203 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Perez, Denise, W,14954 | 70.95 | 0.00 | 0.00 | 0.00 | 70.95 |
| Rivera, Marcus, M,14147 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| Jenkins, Jennifer, B,29237 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| Parker, Alex,29252 | 4389.59 | 0.00 | 3578.27 | 0.00 | 811.32 |
| Ross, Kayla, L,14664 | 3100.55 | 0.00 | 699.10 | 0.00 | 2401.45 |
| Becker, Lindsay, T,23951 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Allen, Elijah, H,28028 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Lu, Autumn,15001 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Carson, Sharon, L,14722 | 1468.59 | 0.00 | 699.10 | 0.00 | 769.49 |
| Arun, Douglas, M,27923 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
Generated 2025-12-24 06:10:25.350 UTC