[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 81 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Malhotra, Frederick,17951 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Gao, Colleen,15108 | 210.54 | 0.00 | 0.00 | 0.00 | 210.54 |
| Ray, Harold, A,13516 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Shen, Julie,22505 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Serrano, Larry,21516 | 3102.25 | 0.00 | 0.00 | 782.99 | 2319.26 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 0.00 | 76.94 |
| Ortega, Robin,17798 | 3058.31 | 0.00 | 0.00 | 2443.35 | 614.96 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Raman, Joe, G,16511 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Martinez, Michele, L,19247 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Patel, Patricia,20569 | 3114.06 | 0.00 | 699.10 | 0.00 | 2414.96 |
| Alonso, Briana,21830 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Tang, Gregory,24048 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Zheng, Lisa, R,13846 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Sai, Jillian,22518 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Phillips, Nathan,25537 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lopez, Allen, O,13821 | 5940.54 | 0.00 | 3578.27 | 0.00 | 2362.27 |
| Martinez, Jarrod, H,22313 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Kelly, Dalton, L,15634 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
Generated 2025-12-24 05:57:06.291 UTC