[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 46 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Simmons, Jack, K,25773 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Ruiz, Gerald, C,21838 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Price, Eduardo, W,22761 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Brooks, Seth,11746 | 77.27 | 0.00 | 0.00 | 42.28 | 34.99 |
| Patel, Johnathan,19289 | 2765.40 | 0.00 | 0.00 | 1000.44 | 1764.96 |
| Rivera, Jennifer, S,15545 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Bryce, B,14562 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanchez, Cassandra, T,13508 | 128.97 | 0.00 | 0.00 | 128.97 | 0.00 |
| Ramirez, Patrick,18602 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| King, Noah,25876 | 4629.07 | 0.00 | 3374.99 | 0.00 | 1254.08 |
| Wu, Stacey, W,20286 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Turner, Logan, K,12143 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Bennett, Alexia,26690 | 132.47 | 0.00 | 0.00 | 0.00 | 132.47 |
| Suarez, Latasha,11471 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Barnes, Julian, A,24526 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
Generated 2025-12-22 01:18:27.569 UTC