[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 16 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Tang, Tonya,20917 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Ruiz, Juan,28746 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lin, Randy,14540 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Yuan, Barbara,21515 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Carlson, Joe, L,25627 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Ross, Gabriel, K,16314 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Gill, Marvin, M,17821 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Johnsen, Rebekah, J,19919 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Raji, April, L,14981 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Beck, Clayton,11579 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Martin, Teresa, D,22588 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Liang, Jessie,19513 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Alvarez, Kathleen, R,17793 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Jackson, Kayla, R,20060 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Martinez, Evelyn, J,17204 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Chen, Dennis, M,17627 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Suarez, Max, A,14809 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Lin, Lacey,13815 | 114.55 | 0.00 | 0.00 | 0.00 | 114.55 |
| Lin, Franklin, M,24557 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gonzales, Isabella, R,14815 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Prasad, Martin,15089 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 |
| Carter, Miguel,13776 | 70.57 | 0.00 | 0.00 | 0.00 | 70.57 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Serrano, Erika,12394 | 5635.91 | 0.00 | 0.00 | 2049.10 | 3586.81 |
| Gonzalez, Bob, S,24569 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Dominguez, Deanna,23779 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rai, Dale, E,21739 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Goel, Willie, T,22656 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Kelly, Dalton, L,15634 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Zhou, Alejandro, A,12304 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ramos, Orlando,24154 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sara, Erick, M,25448 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Jimenez, Renee,14778 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Xu, Laura, D,16287 | 4538.84 | 0.00 | 0.00 | 2181.56 | 2357.28 |
| Navarro, Audrey, S,26937 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Zheng, Nuan,13604 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Ward, Marcus, L,19511 | 3524.36 | 0.00 | 0.00 | 1000.44 | 2523.92 |
| Martin, Carolyn, M,12652 | 182.94 | 0.00 | 0.00 | 0.00 | 182.94 |
| Gao, Lacey, C,16531 | 3291.80 | 0.00 | 0.00 | 2443.35 | 848.45 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Sharma, Willie, W,22427 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Vazquez, Theodore, T,16831 | 7206.37 | 0.00 | 0.00 | 2443.35 | 4763.02 |
Generated 2025-12-23 11:39:08.404 UTC