[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 61 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alexander, Ian, D,26281 | 3335.24 | 0.00 | 0.00 | 2071.42 | 1263.82 |
| Rai, Alison, M,23017 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Collins, Seth,23927 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Raji, Chad,26062 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Ortega, Wendy, B,15094 | 7108.87 | 0.00 | 0.00 | 2181.56 | 4927.31 |
| Gutierrez, Joanna, M,15894 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Washington, Kyle, C,29255 | 4389.59 | 0.00 | 3578.27 | 0.00 | 811.32 |
| Patel, Marie,22397 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| He, Clayton,25802 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Ramos, Lawrence, P,26493 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Miller, Ashley, V,23516 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Washington, Mariah,26343 | 2800.44 | 0.00 | 0.00 | 2049.10 | 751.34 |
| Xu, Jon, D,16572 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Bennett, Emily, A,18682 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chander, Kurt, F,13176 | 4753.32 | 0.00 | 2443.35 | 0.00 | 2309.97 |
| Prasad, Heidi, M,16197 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Srini, Candace,15437 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Jai, Arturo, T,24180 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Torres, Erik, J,14919 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Prasad, Deanna,18009 | 2435.08 | 0.00 | 699.10 | 0.00 | 1735.98 |
| Jai, Colleen,23831 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Morgan, Hailey, G,22753 | 724.47 | 0.00 | 0.00 | 0.00 | 724.47 |
| Alvarez, Latasha,18047 | 2736.42 | 0.00 | 1000.44 | 0.00 | 1735.98 |
| Vazquez, Kathleen, M,12500 | 4475.38 | 0.00 | 0.00 | 2071.42 | 2403.96 |
| Young, Logan,27391 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Lal, Nathan, E,11273 | 273.23 | 0.00 | 0.00 | 0.00 | 273.23 |
| Hayes, Ana,17044 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Baker, Carlos,15419 | 3102.98 | 0.00 | 0.00 | 782.99 | 2319.99 |
| Morris, Gabrielle, A,12148 | 82.93 | 0.00 | 0.00 | 0.00 | 82.93 |
| Diaz, Victor, L,12481 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
Generated 2025-12-23 09:11:01.607 UTC