[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 688 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Robinson, Matthew, D,29376 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Deng, Nichole,19933 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Brenda,25656 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Garcia, Tabitha,27778 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Coleman, Alexis, M,11244 | 7175.75 | 0.00 | 3399.99 | 2354.99 | 1420.77 |
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2071.42 | 3090.31 |
| Moreno, Gary, E,21544 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Liang, Marshall, J,25447 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 2181.56 | 0.00 | 819.46 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Ruiz, Ricky,20718 | 3283.43 | 0.00 | 0.00 | 782.99 | 2500.44 |
| McDonald, Deborah, R,16275 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Dominguez, Lawrence, C,17225 | 6986.87 | 0.00 | 0.00 | 2181.56 | 4805.31 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Chapman, Bob, W,21134 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chande, Priscilla,29358 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Gutierrez, Walter,25141 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Goel, Kara,16465 | 3271.79 | 0.00 | 0.00 | 2443.35 | 828.44 |
| Raman, Joel,16317 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Carlson, Ruben, J,25304 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Tang, Alejandro, L,11542 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 0.00 | 1666.79 |
| Carlson, Lee, S,21079 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
Generated 2025-12-24 06:57:34.077 UTC