[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2360 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Kristi, C,21029 | 1934.75 | 0.00 | 0.00 | 782.99 | 1151.76 |
| Bailey, Ian, R,22275 | 615.47 | 0.00 | 0.00 | 615.47 | 0.00 |
| Jordan, Gerald, L,19053 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Parker, Logan, A,12306 | 74.97 | 0.00 | 0.00 | 0.00 | 74.97 |
| Cook, Gabriella,26460 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Nara, Kelvin, E,15672 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Stone, Michelle,13307 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Wright, Jesse, E,27199 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Alexander, Robert,14025 | 1586.38 | 0.00 | 1000.44 | 0.00 | 585.94 |
| Bryant, Sydney, S,11412 | 9879.96 | 0.00 | 3374.99 | 2366.94 | 4138.03 |
| Gray, Xavier,28643 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Oliver, Alisha, N,20278 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Miller, Cameron,21845 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rivera, Emma, J,28844 | 4337.56 | 0.00 | 3578.27 | 0.00 | 759.29 |
| Zhao, Brittney, M,25610 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
Generated 2025-12-17 20:37:28.878 UTC