[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Max, J,23908 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| She, Omar, K,15448 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Scott, Jack, A,26510 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Brooks, Garrett, L,18425 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Griffin, Luke,13867 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Sharma, Katrina, M,11614 | 4438.06 | 0.00 | 0.00 | 2049.10 | 2388.96 |
| Clark, Alexis,25039 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Rivera, Kaylee, L,24419 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Luo, Willie, C,22682 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Shan, Kevin,18386 | 2309.97 | 0.00 | 0.00 | 0.00 | 2309.97 |
| Vance, Ross, J,19080 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Roberts, Isaiah, M,27211 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Baker, Connor,26345 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Flores, Oscar, L,29415 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Nicholls, Melody,27327 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Tang, Clayton,21821 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Cox, Jacqueline, G,22246 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Perez, Ian, L,17469 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Dominguez, Alfredo, F,28443 | 3374.99 | 0.00 | 3374.99 | 0.00 | 0.00 |
| Zhang, Karen, K,18035 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Martinez, Natalie,28867 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Harris, Chloe,20201 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Ye, Mandy,19475 | 1394.93 | 0.00 | 0.00 | 1394.93 | 0.00 |
| Clark, Morgan,21502 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
Generated 2025-12-23 14:31:53.950 UTC