[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 343 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| McDonald, Harold, J,15051 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Suri, Martin,16589 | 7343.69 | 0.00 | 0.00 | 2443.35 | 4900.34 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raji, Karla, V,15929 | 6944.58 | 0.00 | 2181.56 | 0.00 | 4763.02 |
| Kovar, Shane, L,12294 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Vazquez, Theodore, T,16831 | 7206.37 | 0.00 | 0.00 | 2443.35 | 4763.02 |
| Long, Miguel,24853 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mehta, Cynthia,14175 | 108.96 | 0.00 | 0.00 | 0.00 | 108.96 |
| Chander, Warren, A,17965 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Dominguez, Lori,12648 | 6817.60 | 0.00 | 0.00 | 2049.10 | 4768.50 |
| Serrano, Sheila, C,21018 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Kumar, Raul, B,12857 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| She, Ramon,18000 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Yuan, Katie,19459 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Gutierrez, Gina, A,21092 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 |
| Zeng, Valerie,17977 | 2966.03 | 0.00 | 0.00 | 2181.56 | 784.47 |
| Alvarez, Krista,19467 | 3485.38 | 0.00 | 0.00 | 1000.44 | 2484.94 |
| Torres, Renee, L,19510 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Sharma, Katie,21106 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Malhotra, Raymond, T,13251 | 6844.42 | 0.00 | 0.00 | 2049.10 | 4795.32 |
| Suarez, Reginald,18177 | 7043.56 | 0.00 | 0.00 | 2181.56 | 4862.00 |
| Ruiz, Pedro,24034 | 1203.46 | 0.00 | 0.00 | 0.00 | 1203.46 |
| Thompson, Morgan, Q,24011 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Kelly, Dalton, L,15634 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Rana, Kristina,27847 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Black, Mario, M,27905 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chen, Dennis, M,17627 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Cox, Taylor,11436 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Rai, Alisha,26848 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Lopez, Raymond, G,27317 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 0.00 | 1000.44 | 636.94 |
| Martinez, Donald, D,25482 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Holt, Roger,27140 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| Zhou, Claudia, M,11247 | 7131.51 | 0.00 | 3374.99 | 2340.23 | 1416.29 |
| Coleman, Jessica,13553 | 5603.24 | 0.00 | 0.00 | 2071.42 | 3531.82 |
| Wood, Julian, A,18166 | 7200.37 | 0.00 | 0.00 | 2443.35 | 4757.02 |
| Sara, Cory, A,21105 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Lu, Bianca,13252 | 6820.46 | 0.00 | 0.00 | 2071.42 | 4749.04 |
| Wu, Rafael,12745 | 5199.72 | 0.00 | 0.00 | 2071.42 | 3128.30 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zhang, Trisha,18156 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Bryant, Ian,27319 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Rogers, Melissa, J,28415 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Deng, Lindsay, K,29447 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Jimenez, Diana, M,17776 | 72.25 | 0.00 | 0.00 | 0.00 | 72.25 |
| Shan, Grant,26215 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 2071.42 | 3553.83 |
| Tang, Brad,25489 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Schmidt, Marc,12808 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Shen, Jaime,13765 | 7152.09 | 0.00 | 3578.27 | 0.00 | 3573.82 |
| Xie, Carly, R,13253 | 6774.45 | 0.00 | 0.00 | 2071.42 | 4703.03 |
| Zeng, Margaret, M,16191 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Howard, Timothy,26356 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Cox, Isaiah, E,13584 | 8361.29 | 3578.27 | 0.00 | 0.00 | 4783.02 |
| Parker, Wyatt,25325 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sara, Andre, M,13661 | 5913.24 | 3578.27 | 0.00 | 0.00 | 2334.97 |
Generated 2025-12-23 07:20:45.369 UTC