[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 23 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wu, Jessie, L,23792 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Cox, Juan, A,28281 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Barnes, Melissa, K,12888 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Cooper, Bryan,28973 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Deng, Tony,27309 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Harui, Roger,11509 | 196.29 | 0.00 | 0.00 | 0.00 | 196.29 |
| Gao, Steve, J,14797 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| Anderson, Julia,21309 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Shan, Christy, M,16551 | 5032.76 | 0.00 | 0.00 | 2443.35 | 2589.41 |
| Young, Jason,16441 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Moore, Brianna,21594 | 1169.97 | 0.00 | 0.00 | 0.00 | 1169.97 |
| Raji, Ashlee, L,15342 | 1646.96 | 0.00 | 0.00 | 782.99 | 863.97 |
| Cox, Trinity,22043 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ortega, Jacquelyn, D,15305 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
Generated 2025-12-21 17:46:01.776 UTC