[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 312 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lee, Hannah, F,15713 | 37.59 | 0.00 | 0.00 | 0.00 | 37.59 |
| Lal, Nichole, P,25753 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Townsend, Trinity, L,12367 | 160.45 | 0.00 | 0.00 | 49.99 | 110.46 |
| McDonald, Jenny,16543 | 53.96 | 0.00 | 0.00 | 0.00 | 53.96 |
| Diaz, Erik, S,11565 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Xie, Carl, R,18136 | 6904.60 | 0.00 | 0.00 | 2181.56 | 4723.04 |
| Subram, Bobby, J,29373 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Rowe, Alberto, W,26973 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Nath, Sheena,25800 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Brown, Samuel, M,26999 | 57.98 | 0.00 | 0.00 | 0.00 | 57.98 |
| Liang, Wesley, A,12123 | 5837.84 | 0.00 | 2049.10 | 2351.96 | 1436.78 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Chandra, Sergio, A,22837 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 2398.47 | 1249.84 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vance, Douglas,16387 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Chen, Krystal, D,13530 | 186.28 | 0.00 | 0.00 | 0.00 | 186.28 |
| Raman, Joel,16317 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Lu, Colin, H,21069 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Martin, Joy, L,13544 | 108.44 | 0.00 | 0.00 | 0.00 | 108.44 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Prasad, Regina, A,24192 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Zheng, Lisa, R,13846 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Travers, Linda,29420 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Romero, Robyn, C,27802 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Black, Nichole,22422 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Garcia, Carla,14172 | 75.74 | 0.00 | 0.00 | 0.00 | 75.74 |
| Ortega, Larry, C,18126 | 6945.58 | 0.00 | 0.00 | 2181.56 | 4764.02 |
| Ye, Jamie, C,16329 | 3272.09 | 0.00 | 2443.35 | 0.00 | 828.74 |
| Chander, Christy, E,21548 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
| Zheng, Mandy,24721 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Becker, Louis, J,24193 | 1199.46 | 0.00 | 0.00 | 0.00 | 1199.46 |
| Carlson, Craig, G,17218 | 6907.56 | 0.00 | 0.00 | 2181.56 | 4726.00 |
| Ruiz, Erika, J,19192 | 1682.41 | 0.00 | 1000.44 | 0.00 | 681.97 |
| Perez, Meagan, R,21101 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Lopez, Janelle, G,25500 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Sun, Alisha,18048 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Roberts, Dalton,26387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Howard, Jennifer,16264 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Holt, Katie,27946 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Zhou, Colin,17962 | 2777.52 | 0.00 | 0.00 | 2181.56 | 595.96 |
| Gutierrez, Kellie, K,17966 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Vazquez, Cheryl, A,17948 | 3045.30 | 0.00 | 0.00 | 2443.35 | 601.95 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Munoz, Walter,21056 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Yuan, Katie,19459 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Gutierrez, Gina, A,21092 | 2511.26 | 0.00 | 0.00 | 2511.26 | 0.00 |
| 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 |
| Ward, Mackenzie, D,21130 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Xie, Carly, R,13253 | 6774.45 | 0.00 | 0.00 | 2071.42 | 4703.03 |
| Suarez, Reginald,18177 | 7043.56 | 0.00 | 0.00 | 2181.56 | 4862.00 |
| Samant, Mandar,12873 | 5676.24 | 0.00 | 0.00 | 2071.42 | 3604.82 |
| Goel, Sharon, M,19430 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Hu, Louis,16187 | 34.92 | 0.00 | 0.00 | 0.00 | 34.92 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 29.98 | 103.95 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Carlson, Linda, J,12609 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Jenkins, Blake,28907 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ms., Shock, Misty,24869 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Shawn, C,13845 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Gutierrez, Alberto, R,15461 | 88.96 | 0.00 | 0.00 | 83.97 | 4.99 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Vazquez, Michele,16934 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 2451.30 | 0.00 |
| Arun, Virginia,25655 | 571.72 | 0.00 | 0.00 | 571.72 | 0.00 |
| Prasad, Mayra,11238 | 7542.77 | 3399.99 | 0.00 | 3579.82 | 562.96 |
| Walker, Sarah, R,13814 | 230.04 | 0.00 | 0.00 | 122.96 | 107.08 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Goel, Willie, T,22656 | 1169.46 | 0.00 | 0.00 | 1169.46 | 0.00 |
| Xie, Mario,13687 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Madan, Ross, C,27929 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 3578.27 | 0.00 | 0.00 | 3593.31 |
| Edwards, Julia, M,16200 | 96.95 | 0.00 | 0.00 | 39.98 | 56.97 |
| Zhou, Claudia, M,11247 | 7131.51 | 3374.99 | 0.00 | 2340.23 | 1416.29 |
| Deng, Nichole,19933 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Ramos, Teresa,13689 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 777.34 | 2373.96 |
| Bailey, Ariana, J,13691 | 5976.74 | 3578.27 | 0.00 | 0.00 | 2398.47 |
| Coleman, Alexis, M,11244 | 7175.75 | 3399.99 | 0.00 | 3166.31 | 609.45 |
| Hernandez, Anne, B,11240 | 7586.23 | 3399.99 | 0.00 | 2369.96 | 1816.28 |
| Hernandez, Kaitlyn, S,25647 | 563.77 | 0.00 | 0.00 | 563.77 | 0.00 |
| Brown, Nicole,11334 | 8154.02 | 3399.99 | 0.00 | 2334.97 | 2419.06 |
| Browning, Casey,16449 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Perez, Michele, K,13772 | 5928.25 | 3578.27 | 0.00 | 0.00 | 2349.98 |
| Simpson, Lindsay, E,25746 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Griffin, Spencer,13784 | 7138.10 | 3578.27 | 0.00 | 0.00 | 3559.83 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Romero, Jerome,11337 | 8162.00 | 3374.99 | 0.00 | 2388.96 | 2398.05 |
| Kapoor, George, L,13676 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Nara, Clarence, G,20054 | 3338.04 | 699.10 | 0.00 | 0.00 | 2638.94 |
| Foster, Mya, M,23230 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Liu, Shannon, D,11250 | 7116.25 | 3399.99 | 0.00 | 2339.97 | 1376.29 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 0.00 | 3693.28 |
| Jackson, Kayla, R,20060 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
| Xu, Willie, J,14157 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Miller, Emily, R,11333 | 8163.31 | 3399.99 | 0.00 | 2344.26 | 2419.06 |
| Arun, Rachael, J,23976 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kumar, Clayton,13841 | 6624.60 | 3578.27 | 0.00 | 751.34 | 2294.99 |
| Sharma, Grant, R,23966 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Perez, Manuel, C,13777 | 7147.07 | 0.00 | 3578.27 | 0.00 | 3568.80 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| He, Lacey,14429 | 8394.29 | 0.00 | 3578.27 | 0.00 | 4816.02 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Patel, Emmanuel,14427 | 8451.26 | 0.00 | 3578.27 | 0.00 | 4872.99 |
| Mr., Saravan, K.,14974 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Malhotra, Jay,14159 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Chande, Kelsey, K,14846 | 6744.57 | 0.00 | 3578.27 | 0.00 | 3166.30 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Raji, Tara,12385 | 5118.75 | 0.00 | 0.00 | 2071.42 | 3047.33 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hughes, Kayla,14982 | 152.45 | 0.00 | 0.00 | 118.47 | 33.98 |
| Wu, Jenny, S,23944 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Jimenez, Jessie,11344 | 8119.81 | 0.00 | 3399.99 | 2297.28 | 2422.54 |
Generated 2025-11-06 19:45:22.701 UTC