[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 751 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sai, Gerald, L,27894 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| Deng, Julie,25631 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Tara,12385 | 5118.75 | 0.00 | 0.00 | 2071.42 | 3047.33 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Srini, Virginia,20048 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Dominguez, Ruben,16573 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Liu, Mandy,17888 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Subram, Ebony, K,26216 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Zheng, Valerie, R,19312 | 1564.70 | 0.00 | 0.00 | 1000.44 | 564.26 |
| Lopez, Allen, O,13821 | 5940.54 | 0.00 | 3578.27 | 0.00 | 2362.27 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
| Martin, Audrey,13791 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Washington, Kelly, M,28748 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Howard, Grace, J,20864 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Goel, Warren, A,13678 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Anand, Colleen, N,12647 | 6886.60 | 0.00 | 0.00 | 2049.10 | 4837.50 |
| Zhu, Autumn,14840 | 157.96 | 0.00 | 0.00 | 0.00 | 157.96 |
| Li, Sandra,13679 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Raji, Raul, P,21135 | 103.95 | 0.00 | 0.00 | 0.00 | 103.95 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 0.00 | 3648.31 |
| Sanders, Richard, D,21511 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Michele, K,13772 | 5928.25 | 0.00 | 3578.27 | 0.00 | 2349.98 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gao, Claudia,13690 | 7162.08 | 0.00 | 3578.27 | 0.00 | 3583.81 |
| Ruiz, Theodore,20052 | 3214.03 | 0.00 | 699.10 | 0.00 | 2514.93 |
| Sara, Arthur, D,23753 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Zhou, Curtis,25505 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Chander, Christine, L,17839 | 34.97 | 0.00 | 0.00 | 0.00 | 34.97 |
| Li, Darryl, T,24549 | 2514.93 | 0.00 | 0.00 | 0.00 | 2514.93 |
| Blue, Oscar, L,27008 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Perez, Clifford, R,15690 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Gutierrez, Wendy,12610 | 101.95 | 0.00 | 0.00 | 0.00 | 101.95 |
| Hu, Darryl,24868 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Campbell, Jackson,11575 | 6806.12 | 0.00 | 2049.10 | 0.00 | 4757.02 |
| Perez, Manuel, C,13777 | 7147.07 | 0.00 | 3578.27 | 0.00 | 3568.80 |
| Patterson, Jessica,17182 | 6950.60 | 0.00 | 0.00 | 2181.56 | 4769.04 |
| Wu, Jake, E,22446 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Sharma, Wayne, E,19175 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Cai, Jamie, S,13505 | 127.93 | 0.00 | 0.00 | 0.00 | 127.93 |
| Rodriguez, Bruce,28473 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xie, Sheena,18041 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Suri, Martin,16589 | 7343.69 | 0.00 | 0.00 | 2443.35 | 4900.34 |
| He, Lacey,14429 | 8394.29 | 0.00 | 3578.27 | 0.00 | 4816.02 |
| Bailey, Xavier,12305 | 4940.39 | 0.00 | 0.00 | 2071.42 | 2868.97 |
| Rai, Barbara, J,22451 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Deng, Edwin, A,17085 | 2986.03 | 0.00 | 0.00 | 2181.56 | 804.47 |
| Black, Nichole,22422 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Liu, Eugene,14712 | 6660.59 | 0.00 | 3578.27 | 0.00 | 3082.32 |
| Liang, Marshall, J,25447 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
Generated 2026-01-04 05:47:02.244 UTC