[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 314 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Michele, J,27819 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Suarez, Larry, D,28694 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Shan, Tommy, H,22614 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Lin, Curtis, N,21858 | 2492.32 | 0.00 | 0.00 | 2492.32 | 0.00 |
| Zeng, Sandra,25608 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Dominguez, Jay, A,21857 | 2487.33 | 0.00 | 0.00 | 2487.33 | 0.00 |
| Sharma, Ricardo,16512 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Blanco, Jill,17838 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Martin, Jacquelyn, M,17763 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Gomez, Beth, C,13254 | 6801.13 | 0.00 | 0.00 | 2049.10 | 4752.03 |
| Powell, Christian,19522 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Holt, Brittney,19523 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Johnson, Lucas,13509 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Lal, Cassie,12626 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Diaz, Blake, E,18135 | 6921.58 | 0.00 | 0.00 | 2181.56 | 4740.02 |
| Raman, Bryant, S,19048 | 4765.63 | 0.00 | 0.00 | 2443.35 | 2322.28 |
| Lu, Dawn, G,27833 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Howard, Jennifer,16264 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Alvarez, Roberto,28387 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Moreno, Jamie,22526 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Carlson, Tyrone, S,22662 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Reed, Taylor,23983 | 1195.47 | 0.00 | 0.00 | 0.00 | 1195.47 |
| Price, Brittany,12492 | 5166.41 | 0.00 | 0.00 | 2049.10 | 3117.31 |
| Rai, Colin, W,24573 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Blanco, Max,26360 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Sanz, Kendra,17753 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Williams, Emma, K,16325 | 171.27 | 0.00 | 0.00 | 0.00 | 171.27 |
| Wu, Rosa,16461 | 3287.32 | 0.00 | 0.00 | 2443.35 | 843.97 |
| Alexander, Riley,22799 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Hu, Louis,16187 | 34.92 | 0.00 | 0.00 | 0.00 | 34.92 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Patel, Rebekah, R,22396 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| McDonald, Deborah, R,16275 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Chande, Lacey, A,24555 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Zeng, Alan, M,22321 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Fernandez, Deanna,24554 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhou, Leah, L,22309 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raman, Andre, D,24079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Liang, Jeffery,15711 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Harris, Jonathan,26220 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Huang, Todd,12463 | 5202.22 | 0.00 | 0.00 | 2071.42 | 3130.80 |
| Rana, Cassandra,13407 | 6904.10 | 0.00 | 0.00 | 2049.10 | 4855.00 |
| Martinez, David, R,20869 | 2542.96 | 0.00 | 0.00 | 782.99 | 1759.97 |
| Morgan, Makayla, C,27156 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| 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 |
| Moreno, Kari, S,15052 | 44.57 | 0.00 | 0.00 | 0.00 | 44.57 |
| 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 |
| Ortega, Beth, A,12277 | 5666.52 | 0.00 | 0.00 | 2071.42 | 3595.10 |
| Ashe, Bruce,12264 | 5662.90 | 0.00 | 0.00 | 3292.94 | 2369.96 |
| Browning, Casey,16449 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Tang, Johnny,15119 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Yang, Kelvin,13404 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Lin, Candice, K,19506 | 3480.38 | 0.00 | 0.00 | 1000.44 | 2479.94 |
| Ye, Ernest, A,22558 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Randall, D,22539 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Diaz, Neil, C,18181 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Moreno, Albert,12402 | 5218.40 | 0.00 | 0.00 | 2049.10 | 3169.30 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Ramos, Cheryl, A,25682 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Prasad, Frederick,17810 | 87.94 | 0.00 | 0.00 | 0.00 | 87.94 |
| Dominguez, Deanna,23779 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Serrano, Daisy, P,24187 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Navarro, Shannon, R,15106 | 8421.28 | 0.00 | 3578.27 | 0.00 | 4843.01 |
| Raman, Tammy,12126 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Liang, Jessie,19513 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Deng, Shawn, C,16590 | 168.95 | 0.00 | 0.00 | 0.00 | 168.95 |
| 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 |
| Ruiz, Stacy,16823 | 7242.35 | 0.00 | 0.00 | 2443.35 | 4799.00 |
| Sara, Levi, S,12540 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Zhou, Colin,17962 | 2777.52 | 0.00 | 0.00 | 2181.56 | 595.96 |
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| 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 |
| Smith, Tabitha,14787 | 163.45 | 0.00 | 0.00 | 0.00 | 163.45 |
| Zhou, Glenn, A,12326 | 63.98 | 0.00 | 0.00 | 0.00 | 63.98 |
| Gomez, Robyn,16046 | 3963.14 | 0.00 | 2443.35 | 0.00 | 1519.79 |
| Chander, Priscilla,16530 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Navarro, Beth,13534 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| 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 |
| Kapoor, Johnathan,20576 | 3147.96 | 0.00 | 782.99 | 0.00 | 2364.97 |
| Alvarez, Lance, J,16190 | 79.25 | 0.00 | 0.00 | 0.00 | 79.25 |
| Thomas, Ryan,22532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| Dominguez, Victor, K,14784 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Smith, Jasmine,28891 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Goel, Warren, A,13678 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Chavez, Colleen, H,20049 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Ramos, Teresa,13689 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Srini, Ebony, A,17959 | 2748.83 | 0.00 | 0.00 | 2181.56 | 567.27 |
| 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 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Liang, Cedric, R,19941 | 3078.06 | 699.10 | 0.00 | 0.00 | 2378.96 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Suri, Cynthia,22589 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Jenkins, Spencer, S,14862 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Patel, Emmanuel,14427 | 8451.26 | 0.00 | 3578.27 | 0.00 | 4872.99 |
Generated 2025-12-23 11:53:13.404 UTC