[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1203 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, Chelsea,22086 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Davis, Sydney,17791 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Torres, Marcus,25497 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Srini, Donald,14149 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Carter, Logan, A,12475 | 4438.38 | 0.00 | 0.00 | 2071.42 | 2366.96 |
| Jackson, Logan, D,21751 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Murphy, Haley,21706 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Wright, Luis,18761 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramirez, Allison,28440 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Yang, Gilbert, M,19370 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| James, Joan,13458 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Vance, Ross, J,19080 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Zhang, Gilbert, E,17630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patterson, Isabel, M,22288 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Patterson, Ethan, R,24829 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
Generated 2025-12-24 06:11:34.167 UTC