[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 37 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Ramirez, Michelle,25198 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Perez, James, L,16385 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 | 0.00 |
| McDonald, Claudia, E,15780 | 3244.96 | 0.00 | 0.00 | 782.99 | 2461.97 | 0.00 |
| Richardson, Cody,23922 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Thomas, Hannah,14295 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 | 0.00 |
| Brooks, Taylor, L,24313 | 45.58 | 0.00 | 0.00 | 0.00 | 45.58 | 0.00 |
| Harris, Olivia, J,21638 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 | 0.00 |
| Chen, Dylan,16781 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 | 0.00 |
| Ye, Lisa, L,27855 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 | 0.00 |
| Kelly, Makayla,20340 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Wright, Jenna,11291 | 5873.26 | 0.00 | 3578.27 | 2294.99 | 0.00 | 0.00 |
| Lee, Victoria,27269 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 | 0.00 |
| Phillips, Hunter, G,25041 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| Blanco, Ebony, J,17473 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Hall, Eric, C,27155 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Davis, Charles,17609 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 | 0.00 |
| Brown, Charles,27051 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 | 0.00 |
| Straatsma, Gerrit, Jan,13605 | 9614.73 | 0.00 | 2443.35 | 0.00 | 7171.38 | 0.00 |
| Reed, Alyssa,29128 | 4349.61 | 0.00 | 3578.27 | 0.00 | 771.34 | 0.00 |
| Fernandez, Brett, L,16214 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 | 0.00 |
| Diaz, Connor,21623 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 | 0.00 |
| Flores, Jonathan, H,28615 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 | 0.00 |
| Martinez, Emily, F,17864 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Hayes, Devin,20101 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 | 0.00 |
| Huang, Kelli,18933 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 | 0.00 |
| Barnes, Jasmine, J,11167 | 3126.33 | 0.00 | 0.00 | 2329.99 | 796.34 | 0.00 |
| Jones, Brandon, C,28145 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Munoz, Wendy, R,22821 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
Generated 2026-01-04 08:53:25.590 UTC