[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ortega, Hector, E,16054 | 3759.36 | 0.00 | 2181.56 | 0.00 | 1577.80 |
| Shen, Maurice, L,26938 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Dominguez, Natasha,23769 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Serrano, Sheila, C,21018 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Sanz, Philip, J,17807 | 81.24 | 0.00 | 0.00 | 0.00 | 81.24 |
| Ortega, Beth, A,12277 | 5666.52 | 0.00 | 0.00 | 2071.42 | 3595.10 |
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Roberts, Nathan,29470 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Nara, Damien, W,26877 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Andersen, Jerry,20975 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Jimenez, Janet, P,17112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Torres, Hector, E,17700 | 2805.53 | 0.00 | 0.00 | 2805.53 | 0.00 |
| Gutierrez, Robin,21104 | 2566.95 | 0.00 | 0.00 | 782.99 | 1783.96 |
| Ramos, Cheryl, A,25682 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Roberts, Dalton,26387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ma, Leah, H,14553 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Shan, Aaron,20730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Martin, Gloria, A,12325 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Weber, Stanley, E,12311 | 116.43 | 0.00 | 0.00 | 0.00 | 116.43 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| Li, Sandra,13679 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Wu, Crystal, W,22672 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Anand, Karla,17185 | 6954.57 | 0.00 | 0.00 | 2181.56 | 4773.01 |
| Chande, Christy,26214 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Munoz, Danny,19355 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 0.00 | 2071.42 | 4757.96 |
| Navarro, Arthur,16198 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Madan, Edgar, M,27131 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
Generated 2025-12-22 07:13:05.677 UTC