[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 27 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Mehta, Ross,23626 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Barnes, Jordyn, L,25279 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| Vazquez, Deanna, R,15887 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| He, Kelvin, A,22585 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 | 0.00 |
| Cai, Alisha,19775 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Sharma, Luke,23005 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 | 0.00 |
| Torres, Bryce, I,21607 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Kelly, Katelyn, L,11260 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 | 0.00 |
| Baker, Sydney, A,22093 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 | 0.00 |
| Russell, Samantha,11211 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Scott, Isaiah, E,12051 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 | 0.00 |
| Murphy, Faith,25996 | 4598.83 | 0.00 | 3374.99 | 0.00 | 1223.84 | 0.00 |
| Ruiz, Anne, J,22708 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 | 0.00 |
| Perez, Jenna,24658 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 | 0.00 |
| Luo, Willie, C,22682 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 | 0.00 |
| Smith, Karen, E,18133 | 5780.47 | 0.00 | 0.00 | 1000.44 | 4780.03 | 0.00 |
Generated 2026-01-04 05:47:23.619 UTC