[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 23 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Munoz, Paula, M,22066 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Watson, Juan, J,15023 | 3079.57 | 0.00 | 699.10 | 0.00 | 2380.47 |
| Sánchez, Sergio, S,15670 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| White, Rachel, S,27529 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Romero, Cheryl, A,25786 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Kapoor, Carla,27001 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Chen, Margaret, F,27941 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Howard, Richard, D,15428 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Baker, Sierra,19465 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lopez, Hailey, M,15470 | 76.96 | 0.00 | 0.00 | 0.00 | 76.96 |
| Peterson, Hailey, R,14866 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Williams, Taylor,13426 | 4498.53 | 0.00 | 0.00 | 2181.56 | 2316.97 |
| Raji, Jaclyn,18289 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Gonzalez, Jesse, D,22750 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| James, Danielle,12978 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Walker, Natalie,12894 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Reed, Juan,25014 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Perez, Adriana, K,14762 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kovar, Troy, J,23604 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Rubio, Brandi, M,23149 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Hall, Logan,24511 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Wu, Kristen, A,23222 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Dominguez, Dwayne, L,25806 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Hernandez, Courtney,11957 | 91.25 | 0.00 | 0.00 | 0.00 | 91.25 |
| Gonzalez, Stanley,16305 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Gonzales, Hannah,21299 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Sharma, Karl, C,15609 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Martin, Daniel,17498 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
Generated 2025-12-21 19:38:09.352 UTC