[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 81 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Zhang, Ernest, M,14612 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lal, Roger,16113 | 2391.95 | 0.00 | 0.00 | 0.00 | 2391.95 | 0.00 |
| Harris, Alyssa, E,24423 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| Ramirez, Katherine,17395 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Anderson, Zachary,11324 | 5945.23 | 0.00 | 3578.27 | 0.00 | 2366.96 | 0.00 |
| Perry, Blake, D,24260 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 | 0.00 |
| Gomez, Erika,11441 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 | 0.00 |
| Turner, Devin, J,23464 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 | 0.00 |
| Butler, Dylan,20121 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Gonzales, Spencer,17206 | 3295.43 | 0.00 | 0.00 | 1000.44 | 2294.99 | 0.00 |
| Bryant, Brandon,27798 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Lewis, Julia,27213 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Cooper, Brian, L,13760 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Patterson, Madison,17779 | 4250.21 | 0.00 | 0.00 | 1000.44 | 3249.77 | 0.00 |
| Wright, Alexandra, E,28995 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 | 0.00 |
| Carter, Jennifer, W,13890 | 2982.02 | 0.00 | 0.00 | 2181.56 | 800.46 | 0.00 |
Generated 2026-01-04 05:47:50.729 UTC