[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Arthur, Ronald, D,14776 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Gutierrez, Eddie, R,28370 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Kapoor, Carolyn, M,16459 | 47.26 | 0.00 | 0.00 | 7.28 | 39.98 |
| Shan, Misty,20868 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Rai, Dale, E,21739 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ruiz, Jill, P,14423 | 141.91 | 0.00 | 0.00 | 0.00 | 141.91 |
| Blanco, Rebekah,18149 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Morris, Savannah,13585 | 8368.29 | 3578.27 | 0.00 | 0.00 | 4790.02 |
| Srini, Virginia,20048 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
| Sanz, Marie,13600 | 8460.25 | 3578.27 | 0.00 | 0.00 | 4881.98 |
| Chavez, Colleen, H,20049 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Mehta, Virginia,13602 | 8376.28 | 3578.27 | 0.00 | 0.00 | 4798.01 |
| Li, Sandra,13679 | 5933.26 | 3578.27 | 0.00 | 0.00 | 2354.99 |
| Hernandez, Anne, B,11240 | 7586.23 | 3399.99 | 0.00 | 2369.96 | 1816.28 |
| Lopez, Allen, O,13821 | 5940.54 | 3578.27 | 0.00 | 0.00 | 2362.27 |
| Shen, Jaime,13765 | 7152.09 | 3578.27 | 0.00 | 0.00 | 3573.82 |
| Griffin, Spencer,13784 | 7138.10 | 3578.27 | 0.00 | 0.00 | 3559.83 |
| Romero, Jerome,11337 | 8162.00 | 3374.99 | 0.00 | 2388.96 | 2398.05 |
| Ruiz, Theodore,20052 | 3214.03 | 699.10 | 0.00 | 2514.93 | 0.00 |
| Wright, Logan, M,13783 | 5955.23 | 3578.27 | 0.00 | 0.00 | 2376.96 |
| Tang, Kurt, G,13847 | 5888.24 | 3578.27 | 0.00 | 0.00 | 2309.97 |
| Nara, Shawn, C,13845 | 5917.24 | 3578.27 | 0.00 | 0.00 | 2338.97 |
| Perez, Manuel, C,13777 | 7147.07 | 3578.27 | 0.00 | 0.00 | 3568.80 |
| He, Lacey,14429 | 8394.29 | 0.00 | 3578.27 | 0.00 | 4816.02 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Torres, Devin, A,23752 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Roberts, Gabrielle, E,29432 | 1307.31 | 0.00 | 0.00 | 0.00 | 1307.31 |
| Alexander, Justin, M,12272 | 5139.73 | 0.00 | 0.00 | 2822.76 | 2316.97 |
| He, Alan, A,12210 | 6825.45 | 0.00 | 2071.42 | 0.00 | 4754.03 |
| Ruiz, Juan,28746 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Moyer, Felicia, C,28880 | 637.96 | 0.00 | 0.00 | 0.00 | 637.96 |
| Gray, Natalie, L,14165 | 5910.55 | 0.00 | 3578.27 | 0.00 | 2332.28 |
| Blanco, Clinton, J,14195 | 8316.29 | 0.00 | 3578.27 | 0.00 | 4738.02 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 776.33 | 2329.98 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Hayes, Riley,14833 | 6679.60 | 0.00 | 3578.27 | 0.00 | 3101.33 |
| Ramos, Anne, R,11351 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Ortega, Carrie, L,11353 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Andersen, Jaclyn,11468 | 6959.82 | 0.00 | 3374.99 | 2319.99 | 1264.84 |
| McDonald, Harold, J,15051 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Collins, Blake,11610 | 6786.44 | 0.00 | 2071.42 | 0.00 | 4715.02 |
| Kapoor, Marco,19512 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Rana, Heidi, M,22475 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Gill, Randall, A,18165 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Hu, Curtis, G,27880 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Patel, Barry, J,26218 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Goel, Gregory,28712 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Navarro, Dwayne, H,11615 | 5205.71 | 0.00 | 2071.42 | 777.34 | 2356.95 |
| Raman, Joe, G,16511 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Sharma, James, L,21049 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Hu, Lisa, L,21118 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Sharma, Wayne, E,19175 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Richardson, Ian,11414 | 7191.77 | 0.00 | 3399.99 | 2398.97 | 1392.81 |
| Sai, Kaitlin, J,14529 | 254.06 | 0.00 | 0.00 | 0.00 | 254.06 |
| Tang, Nichole, C,15630 | 5136.37 | 0.00 | 3578.27 | 806.76 | 751.34 |
| Andersen, Clayton,15631 | 5122.39 | 0.00 | 3578.27 | 801.77 | 742.35 |
| Patel, Patricia,20569 | 3114.06 | 0.00 | 699.10 | 0.00 | 2414.96 |
| Perez, Andre,11491 | 8158.01 | 0.00 | 3374.99 | 2329.98 | 2453.04 |
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 889.45 | 777.34 |
| Wu, Dawn, T,11493 | 6958.80 | 0.00 | 3399.99 | 2329.98 | 1228.83 |
| Gomez, Joy, J,12658 | 6863.44 | 0.00 | 0.00 | 2071.42 | 4792.02 |
| Ortega, Gary,11496 | 7013.79 | 0.00 | 3399.99 | 2398.95 | 1214.85 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Fernandez, Erick, E,15668 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Romero, Sheila,20577 | 3080.27 | 0.00 | 782.99 | 0.00 | 2297.28 |
| Raje, Yolanda,20852 | 2546.96 | 0.00 | 0.00 | 782.99 | 1763.97 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 2343.96 | 2393.06 |
| Diaz, Deanna, D,17720 | 2790.53 | 0.00 | 0.00 | 2181.56 | 608.97 |
| Raje, Melvin,11580 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2849.41 | 2405.47 |
| Zhou, Lisa, L,13809 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 42.97 | 14.98 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Garcia, Bob,19186 | 1562.41 | 0.00 | 1000.44 | 0.00 | 561.97 |
| Ashe, Bethany,19350 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Zheng, Leah, R,12627 | 110.94 | 0.00 | 0.00 | 0.00 | 110.94 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Chander, Sheena, L,16308 | 4551.52 | 0.00 | 2181.56 | 0.00 | 2369.96 |
| Liang, Wesley, A,12123 | 5837.84 | 0.00 | 2049.10 | 2351.96 | 1436.78 |
| Ross, Gabrielle, J,19253 | 1540.43 | 0.00 | 1000.44 | 0.00 | 539.99 |
| Xu, Laura, D,16287 | 4538.84 | 0.00 | 2181.56 | 0.00 | 2357.28 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Raman, Joel,16317 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 2443.35 | 819.48 | 0.00 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 782.99 | 0.00 | 2478.34 |
| Raje, Julie, H,12214 | 6803.92 | 0.00 | 2049.10 | 0.00 | 4754.82 |
| Lal, Omar, S,19193 | 1609.40 | 0.00 | 1000.44 | 0.00 | 608.96 |
| Alonso, Eddie, L,16420 | 2959.00 | 0.00 | 2181.56 | 0.00 | 777.44 |
| Navarro, Joy,16410 | 3242.77 | 0.00 | 2443.35 | 0.00 | 799.42 |
| Sanz, Ebony, I,20711 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Luo, Christy,16277 | 3010.03 | 0.00 | 2181.56 | 0.00 | 828.47 |
| Chande, Nina, D,19263 | 1587.41 | 0.00 | 1000.44 | 0.00 | 586.97 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gill, Craig, R,29379 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 4490.48 | 2334.98 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Ma, Leah, H,14553 | 147.95 | 0.00 | 0.00 | 78.98 | 68.97 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Andersen, Nichole,12653 | 6860.09 | 0.00 | 0.00 | 2049.10 | 4810.99 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Sharma, Katie,21106 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Martin, Billy, B,26849 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kennedy, Kelsey, M,23984 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Navarro, Hector,23907 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Sai, Gerald, L,27894 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Nara, Omar, J,13535 | 59.20 | 0.00 | 0.00 | 0.00 | 59.20 |
| Zeng, Margaret, M,16191 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Prasad, Veronica, J,24199 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Madan, Edgar, M,27131 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
Generated 2025-11-04 05:58:07.197 UTC