[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 2500 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Garcia, Cindy, A,22807 | 71.94 | 0.00 | 0.00 | 0.00 | 71.94 | 0.00 |
| Diaz, Hector, A,26836 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Carter, Caleb, F,11067 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 | 0.00 |
| Flores, Trevor,27676 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 | 0.00 |
| Wang, Marshall, L,11342 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 | 0.00 |
| Carter, Alex, M,12042 | 5975.23 | 0.00 | 3578.27 | 0.00 | 2396.96 | 0.00 |
| Jiménez, Adrienne, L,24512 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| Torres, Beth,24623 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| James, Marcus, E,23719 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Zhou, Jeffery, M,24848 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 | 0.00 |
| Lopez, Monica, M,22660 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Mehta, Cynthia,14175 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 | 0.00 |
| Li, Jake, L,19583 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 | 0.00 |
| Stewart, Gabrielle, R,18748 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 | 0.00 |
| Washington, Robert, J,14906 | 45.58 | 0.00 | 0.00 | 0.00 | 45.58 | 0.00 |
| Lal, Justin,22357 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 | 0.00 |
| Turner, Morgan,11823 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 | 0.00 |
| King, Rebecca,16233 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 | 0.00 |
| Powell, Jason, L,13946 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 | 0.00 |
| Rana, Ebony, J,17190 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 | 0.00 |
| Xu, Claudia, J,14179 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 | 0.00 |
| Blanco, Gary,17712 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 | 0.00 |
| Rai, Leonard, C,23221 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Griffin, Oscar, F,22556 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 | 0.00 |
| Reed, Mackenzie, M,19735 | 572.26 | 0.00 | 0.00 | 0.00 | 572.26 | 0.00 |
| Prasad, Ruben,14501 | 2994.09 | 699.10 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Gonzalez, Chloe,14461 | 3310.41 | 0.00 | 0.00 | 1000.44 | 2309.97 | 0.00 |
| Stewart, Charles, F,23257 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Wood, Melanie, R,23734 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| James, Cody, A,12176 | 162.28 | 0.00 | 0.00 | 0.00 | 162.28 | 0.00 |
| Zhang, Randy,12601 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 | 0.00 |
Generated 2026-01-04 05:47:22.550 UTC