[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1001 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Sanchez, Melanie,13264 | 3687.29 | 0.00 | 0.00 | 0.00 | 3687.29 | 0.00 |
| Sanders, Sydney,27073 | 4433.17 | 0.00 | 0.00 | 2049.10 | 2384.07 | 0.00 |
| Robinson, Eduardo,16263 | 7243.36 | 0.00 | 0.00 | 2443.35 | 4800.01 | 0.00 |
| Hall, Isabella,18157 | 3399.41 | 0.00 | 0.00 | 1000.44 | 2398.97 | 0.00 |
| Walker, Christian,11855 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 | 0.00 |
| Brooks, Garrett, L,18425 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Long, Hannah, E,11157 | 41.28 | 0.00 | 0.00 | 0.00 | 41.28 | 0.00 |
| Perez, Katelyn, K,11656 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 | 0.00 |
| Green, Charles,19831 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 | 0.00 |
| Washington, Kyle, C,29255 | 4389.59 | 0.00 | 3578.27 | 0.00 | 811.32 | 0.00 |
| Hayes, Faith,26539 | 4469.44 | 0.00 | 0.00 | 2049.10 | 2420.34 | 0.00 |
| Zeng, Jaclyn, R,18086 | 1723.96 | 0.00 | 0.00 | 0.00 | 1723.96 | 0.00 |
| Baker, Lucas,11807 | 153.46 | 0.00 | 0.00 | 0.00 | 153.46 | 0.00 |
| Alonso, Alberto,25350 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 | 0.00 |
| Russell, Antonio, L,14432 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 | 0.00 |
| Diaz, Julian,15813 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 | 0.00 |
| Blanco, Naomi, K,26405 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 | 0.00 |
| Hughes, Angela,15948 | 3092.96 | 0.00 | 0.00 | 782.99 | 2309.97 | 0.00 |
| Beck, Christy, A,19366 | 1617.46 | 0.00 | 0.00 | 782.99 | 834.47 | 0.00 |
| Torres, Jaime, M,23295 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 | 0.00 |
| Davis, Jose,24981 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| Parker, Luke, G,18396 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 | 0.00 |
| Murphy, Victoria, J,15163 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Rodriguez, Nicole, A,20803 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Peterson, Natalie, M,15840 | 3080.27 | 0.00 | 0.00 | 782.99 | 2297.28 | 0.00 |
| Alexander, Jose, J,26627 | 2791.45 | 0.00 | 0.00 | 2049.10 | 742.35 | 0.00 |
| Gao, Barbara,24018 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 | 0.00 |
| Romero, Melody,18134 | 5732.47 | 0.00 | 0.00 | 1000.44 | 4732.03 | 0.00 |
| Alexander, Stephanie,24950 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 | 0.00 |
| Garcia, Madison,24507 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
Generated 2026-01-04 08:53:16.029 UTC