[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 783 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martinez, Brandy, L,12865 | 114.23 | 0.00 | 0.00 | 0.00 | 114.23 |
| Luo, Dale, M,22613 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Liu, Eugene,14712 | 6660.59 | 0.00 | 3578.27 | 0.00 | 3082.32 |
| She, Wayne,23607 | 2451.30 | 0.00 | 0.00 | 2451.30 | 0.00 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Wu, Roger,22630 | 1164.47 | 0.00 | 0.00 | 1164.47 | 0.00 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Diaz, Julio, J,24094 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| She, Donna, D,19346 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Torres, Devin, A,23752 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Sanchez, Darren,12502 | 110.46 | 0.00 | 0.00 | 60.47 | 49.99 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Tang, Nicolas, S,12282 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Ma, Damien,15612 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Zhao, Dennis,20173 | 3181.33 | 0.00 | 699.10 | 0.00 | 2482.23 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Arthur, Ronald, D,14776 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Rana, Cynthia, L,28397 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Suarez, Ross, C,27940 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| McDonald, George,11394 | 8161.97 | 0.00 | 3399.99 | 2342.92 | 2419.06 |
| Harrison, Melody,28468 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Chandra, Regina, M,15057 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Deng, Ricardo,21111 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gonzalez, Preston, L,14156 | 229.57 | 0.00 | 0.00 | 0.00 | 229.57 |
| Patterson, Emma, J,14941 | 6865.57 | 0.00 | 3578.27 | 0.00 | 3287.30 |
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Rubio, Jésus,25616 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alexander, Justin, M,12272 | 5139.73 | 0.00 | 0.00 | 2822.76 | 2316.97 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Butler, Natalie,26401 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hayes, Emily,19184 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gutierrez, Alberto, R,15461 | 88.96 | 0.00 | 0.00 | 0.00 | 88.96 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| He, Rosa, J,15638 | 5162.37 | 0.00 | 3578.27 | 0.00 | 1584.10 |
| Zeng, Brent, S,21110 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Xie, Calvin, A,24858 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sai, Kaitlin, J,14529 | 254.06 | 0.00 | 0.00 | 0.00 | 254.06 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Gomez, Joy, J,12658 | 6863.44 | 0.00 | 0.00 | 2071.42 | 4792.02 |
| Hughes, Adam,24546 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Raje, Yolanda,20852 | 2546.96 | 0.00 | 0.00 | 782.99 | 1763.97 |
| Raje, Melvin,11580 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Deng, Dustin, F,11422 | 7075.27 | 0.00 | 3399.99 | 2334.98 | 1340.30 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Suurs, Paul, J,15669 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| 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 |
| Gonzalez, Geoffrey,11603 | 6767.14 | 0.00 | 2049.10 | 0.00 | 4718.04 |
| Torres, Deb,11550 | 5241.43 | 0.00 | 2049.10 | 777.34 | 2414.99 |
| Sanchez, Brenda,25656 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Morris, Emma, L,17820 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Gomez, Theodore,13503 | 101.25 | 0.00 | 0.00 | 0.00 | 101.25 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Lal, Kelli, J,19173 | 1594.42 | 0.00 | 1000.44 | 0.00 | 593.98 |
| Raman, Joel,16317 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Alonso, Eddie, L,16420 | 2959.00 | 0.00 | 0.00 | 2181.56 | 777.44 |
| Navarro, Joy,16410 | 3242.77 | 0.00 | 0.00 | 2443.35 | 799.42 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Ashe, Bethany,19350 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Subram, Cesar, L,11475 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Cooper, Kimberly, J,22457 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Sara, Arthur, D,23753 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Gutierrez, Arthur, A,12504 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Becker, Kate,16447 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Jordan, Terrance, B,16546 | 3036.53 | 0.00 | 0.00 | 2181.56 | 854.97 |
| Ashe, Bruce,12264 | 5662.90 | 0.00 | 0.00 | 3292.94 | 2369.96 |
| Rai, Casey, M,19308 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Shan, Alicia,27964 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Kelly, Brianna, C,16945 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Shan, Willie,17098 | 2768.53 | 0.00 | 0.00 | 2768.53 | 0.00 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Washington, Isabella,20880 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Miller, Jeremiah,17717 | 2840.01 | 0.00 | 0.00 | 2181.56 | 658.45 |
| Liang, Krystal, S,12404 | 5251.71 | 0.00 | 0.00 | 2071.42 | 3180.29 |
| Jiménez, Derrick, B,17890 | 2753.52 | 0.00 | 0.00 | 2181.56 | 571.96 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Rai, Kelsey, L,19437 | 3480.38 | 0.00 | 0.00 | 3480.38 | 0.00 |
| Nara, Casey, E,17812 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Sharma, Alicia, L,19440 | 3492.76 | 0.00 | 0.00 | 1000.44 | 2492.32 |
| Ramos, Jill,21039 | 2483.98 | 0.00 | 0.00 | 2483.98 | 0.00 |
| Jiménez, Arthur, K,20982 | 2546.96 | 0.00 | 0.00 | 2546.96 | 0.00 |
| Rodriguez, Marie, L,17960 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Chander, Warren, A,17965 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Xu, Ronnie,17892 | 2787.51 | 0.00 | 0.00 | 2181.56 | 605.95 |
| She, Ramon,18000 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Diaz, Armando, P,17978 | 3018.01 | 0.00 | 0.00 | 2181.56 | 836.45 |
| Zeng, Valerie,17977 | 2966.03 | 0.00 | 0.00 | 2181.56 | 784.47 |
| Alvarez, Krista,19467 | 3485.38 | 0.00 | 0.00 | 1000.44 | 2484.94 |
| Jimenez, Frank,21067 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Griffin, Jeremiah,18158 | 6869.61 | 0.00 | 0.00 | 2181.56 | 4688.05 |
| Suarez, Reginald,18177 | 7043.56 | 0.00 | 0.00 | 2181.56 | 4862.00 |
| Black, Shawn, A,19499 | 3492.76 | 0.00 | 0.00 | 3492.76 | 0.00 |
| Lu, Bianca,13252 | 6820.46 | 0.00 | 0.00 | 2071.42 | 4749.04 |
Generated 2025-12-22 02:41:32.480 UTC