[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 938 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kumar, Priscilla, C,14568 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 |
| Suarez, Jill, J,12314 | 7997.92 | 0.00 | 0.00 | 2071.42 | 5926.50 |
| Ye, Jaclyn,23928 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Rana, Brandy, A,15710 | 6316.50 | 0.00 | 0.00 | 2181.56 | 4134.94 |
| King, Natalie, L,26675 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Coleman, Jack,25416 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| White, Michael, A,20780 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Clark, Jeremy, J,18323 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Goel, Edwin,23260 | 93.46 | 0.00 | 0.00 | 0.00 | 93.46 |
| 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 |
| Hayes, Jose, M,15512 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Perez, Denise, W,14954 | 70.95 | 0.00 | 0.00 | 0.00 | 70.95 |
| 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 |
Generated 2025-12-24 07:03:26.619 UTC