[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1246 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Taylor, Joseph, T,12289 | 5645.86 | 0.00 | 0.00 | 2049.10 | 3596.76 |
| Zhang, Margaret, G,16058 | 38.25 | 0.00 | 0.00 | 0.00 | 38.25 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 2049.10 | 3671.27 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gill, Paula, W,28524 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Deng, Nichole,19933 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chen, Dennis, M,17627 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Ortega, Kendra,25592 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Allen, Jada,26866 | 615.46 | 0.00 | 0.00 | 0.00 | 615.46 |
| Alexander, Isabel,22823 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Sun, Stacey, S,19361 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Navarro, Hector,23907 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Moreno, Briana, L,28734 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Shan, Willie,17098 | 2768.53 | 0.00 | 0.00 | 2768.53 | 0.00 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Andersen, Damien, K,29402 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| Raje, Karl,19362 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Lopez, Geoffrey, A,29451 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Raje, Roger, E,11596 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 0.00 | 78.86 |
| He, Warren, L,17192 | 6977.58 | 0.00 | 0.00 | 2181.56 | 4796.02 |
| Carlson, Joe, L,25627 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| She, Warren,21824 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Arun, Rachael, J,23976 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Jai, Christine, J,14814 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Bailey, Garrett,19055 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Sharma, Grant, R,23966 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Kelly, Olivia, L,12391 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Townsend, Trinity, L,12367 | 160.45 | 0.00 | 0.00 | 0.00 | 160.45 |
| Hernandez, Kristi, L,22635 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Suri, Clifford,19369 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Raman, Bruce,20886 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Lu, Clayton, L,23613 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Srini, Stanley,18042 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Suarez, Michele, C,12526 | 5229.38 | 0.00 | 0.00 | 2049.10 | 3180.28 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Alonso, Tanya, K,26942 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Wu, Jenny, S,23944 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sai, Sergio,12473 | 5665.22 | 0.00 | 0.00 | 2071.42 | 3593.80 |
| Li, Heather, C,12803 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Anand, Sharon,26208 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Raji, Marshall, L,27175 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Serrano, Jimmy, L,17632 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Chander, Colin, P,12847 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gonzalez, Ruben, A,22468 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Liang, Krystal, S,12404 | 5251.71 | 0.00 | 0.00 | 2071.42 | 3180.29 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Phillips, Gabriel, R,29443 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Stone, Brent,22811 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Anand, Clayton,20890 | 2527.96 | 0.00 | 0.00 | 782.99 | 1744.97 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Thomas, Miguel,25480 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Ma, Ronnie, C,17815 | 3123.78 | 0.00 | 0.00 | 2443.35 | 680.43 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
Generated 2025-12-24 08:01:12.318 UTC