[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 128 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Lacey,13815 | 114.55 | 0.00 | 0.00 | 0.00 | 114.55 |
| Jai, Christine, J,14814 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Townsend, Trinity, L,12367 | 160.45 | 0.00 | 0.00 | 0.00 | 160.45 |
| Moreno, Kellie, T,16318 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Zhou, Valerie, J,17828 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Li, Jeffery,17969 | 3040.31 | 0.00 | 0.00 | 2443.35 | 596.96 |
| Gonzalez, Bob, S,24569 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Lu, Brittney, A,12848 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Hernandez, Gabriel, J,13805 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Sara, Evelyn,16045 | 3802.37 | 0.00 | 2181.56 | 0.00 | 1620.81 |
| Andersen, Kathryn,21865 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Deng, Karla, C,29382 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 0.00 | 3648.31 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Ortega, Beth, A,12277 | 5666.52 | 0.00 | 0.00 | 2071.42 | 3595.10 |
| Moreno, Kari, S,15052 | 44.57 | 0.00 | 0.00 | 0.00 | 44.57 |
| Jones, Chloe,20838 | 2541.94 | 0.00 | 0.00 | 782.99 | 1758.95 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Rana, Geoffrey,28745 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Malhotra, Allen, A,15102 | 97.35 | 0.00 | 0.00 | 0.00 | 97.35 |
| Shen, Derek, T,22586 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
| Gutierrez, Kellie, K,17966 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Gomez, Joe, E,16574 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Ms., Song, Lolan,19073 | 4760.32 | 0.00 | 0.00 | 2443.35 | 2316.97 |
| Prasad, Sergio, J,19290 | 1605.40 | 0.00 | 0.00 | 1000.44 | 604.96 |
| Hayes, Marcus, A,15657 | 5251.34 | 0.00 | 3578.27 | 0.00 | 1673.07 |
| Perez, Manuel, C,13777 | 7147.07 | 0.00 | 3578.27 | 0.00 | 3568.80 |
| Collins, Richard, S,16256 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Diaz, Blake, E,18135 | 6921.58 | 0.00 | 0.00 | 2181.56 | 4740.02 |
| Srini, Molly, L,27790 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Cai, Lacey, L,12733 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Richardson, Ian,11414 | 7191.77 | 0.00 | 3399.99 | 0.00 | 3791.78 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Shen, Carl, L,19190 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Deng, Shawn, C,16590 | 168.95 | 0.00 | 0.00 | 0.00 | 168.95 |
| Yang, Omar,12566 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Sanz, Marie,13600 | 8460.25 | 3578.27 | 0.00 | 0.00 | 4881.98 |
| Patel, Denise,20179 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Moreno, Albert,12402 | 5218.40 | 0.00 | 0.00 | 2049.10 | 3169.30 |
| Howard, Angel, A,23223 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Blanco, Joe,25675 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Kumar, Roger, C,15922 | 148.20 | 0.00 | 0.00 | 0.00 | 148.20 |
| Guo, Kelvin, H,17705 | 37.26 | 0.00 | 0.00 | 0.00 | 37.26 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Ma, Suzanne, A,26947 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Serrano, Erika,12394 | 5635.91 | 0.00 | 0.00 | 2049.10 | 3586.81 |
| Parker, Haley,14694 | 156.94 | 0.00 | 0.00 | 0.00 | 156.94 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Arun, Emmanuel, R,28463 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raje, Tony,24212 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Suarez, Clinton,22657 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| McDonald, Jenny,16543 | 53.96 | 0.00 | 0.00 | 0.00 | 53.96 |
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Alvarez, Kathleen, R,17793 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Alexander, Isabel,22823 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lee, Hannah, F,15713 | 37.59 | 0.00 | 0.00 | 0.00 | 37.59 |
Generated 2025-12-23 17:40:34.720 UTC