[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Xu, Terrence, L,23743 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Huang, Clarence, C,19341 | 3498.78 | 0.00 | 0.00 | 3498.78 | 0.00 |
| Zhao, Dennis,20173 | 3181.33 | 0.00 | 699.10 | 0.00 | 2482.23 |
| Schmidt, Marc,12808 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Subram, Mayra, C,28446 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Rivera, Chase,28511 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Rodriguez, Ann, S,12315 | 6803.13 | 0.00 | 0.00 | 6803.13 | 0.00 |
| Rai, Kristin, C,12569 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Lu, Rafael, J,22869 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ye, Rosa, C,19940 | 3440.43 | 0.00 | 0.00 | 1000.44 | 2439.99 |
| Xu, Shawn,19328 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Alvarez, Deanna, K,24720 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Perez, Manuel, C,13777 | 7147.07 | 0.00 | 3578.27 | 0.00 | 3568.80 |
| Andersen, Jerry,20975 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Jai, Terrence,27956 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Black, Roger, J,28416 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Srini, Virginia,20048 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
| Kapoor, Johnathan,20576 | 3147.96 | 0.00 | 782.99 | 0.00 | 2364.97 |
| Thomas, Miguel,25480 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Zhao, Sandra, S,22503 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Alonso, Micheal, W,19307 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 782.99 | 0.00 | 2478.34 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Lewis, Katherine,14816 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Patel, Cassandra, P,12465 | 83.42 | 0.00 | 0.00 | 0.00 | 83.42 |
| Navarro, Micheal,23625 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Martin, Teresa, D,22588 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Nara, Kara, E,24566 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Kumar, Grant, A,25510 | 1212.95 | 0.00 | 0.00 | 0.00 | 1212.95 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Allen, Jada,26866 | 615.46 | 0.00 | 0.00 | 0.00 | 615.46 |
| Garcia, Arthur, T,29413 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rubio, Dwayne, D,28527 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 2319.99 | 2398.05 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Brooks, Savannah, R,24558 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Ortega, Leslie,24851 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Serrano, Jill,24026 | 1212.97 | 0.00 | 0.00 | 0.00 | 1212.97 |
| Williams, Jennifer, E,19457 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Fernandez, Chelsea, J,19905 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Saunders, Cynthia,24537 | 2511.32 | 0.00 | 0.00 | 2511.32 | 0.00 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 7.28 | 98.96 |
| Phillips, Nathan,25537 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Mr., Rodman, Jim,20562 | 2994.09 | 0.00 | 699.10 | 0.00 | 2294.99 |
| Srini, Stanley,18042 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Zhang, Margaret, G,16058 | 38.25 | 0.00 | 0.00 | 0.00 | 38.25 |
| Anderson, Kaitlyn, H,24101 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Tang, Johnny,15119 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Andersen, Dale, B,14992 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Black, Mario, M,27905 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Navarro, Lance, C,20850 | 2556.94 | 0.00 | 0.00 | 2556.94 | 0.00 |
| Carlson, Jerome, J,21817 | 791.47 | 0.00 | 0.00 | 0.00 | 791.47 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Darren, K,22315 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanchez, Brenda,25656 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Howard, Jennifer,16264 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Navarro, Erika, K,11476 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Gonzales, Isabella, R,14815 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 1188.46 | 0.00 |
| James, Gabriella, S,22594 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Sara, Erick, M,25448 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Malhotra, Evelyn,12853 | 4354.08 | 0.00 | 0.00 | 2049.10 | 2304.98 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Hernandez, Renee, C,17803 | 2761.02 | 0.00 | 0.00 | 2181.56 | 579.46 |
| Pal, Jon, H,15440 | 6736.56 | 0.00 | 3578.27 | 0.00 | 3158.29 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 2341.97 | 2419.06 |
| Mehta, Virginia,13602 | 8376.28 | 3578.27 | 0.00 | 0.00 | 4798.01 |
| She, Raul,19497 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Morgan, Makayla, C,27156 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
| Gill, Randall, A,18165 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Dominguez, Lawrence, C,17225 | 6986.87 | 0.00 | 0.00 | 2181.56 | 4805.31 |
| Lal, Jerry, L,27822 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Hu, Lisa, L,21118 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Raji, Edwin,11469 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2822.76 | 2338.97 |
| Kumar, Carly, R,24712 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Carlson, Desiree, V,14864 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Raman, Douglas,24545 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zheng, Nuan,13604 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Perez, Jack,19455 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Xu, Mario,26411 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Lopez, Edward, L,26931 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Yang, Jackson,22570 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Zhou, Cara,11350 | 38.47 | 0.00 | 0.00 | 38.47 | 0.00 |
| Zhu, Stacey, E,22636 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| She, Clayton,13785 | 121.83 | 0.00 | 0.00 | 0.00 | 121.83 |
| Russell, Christian, S,22826 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Li, Laura, O,20933 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Cox, Cole, M,25315 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gray, Jessica,19479 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Miller, Jeremiah,17717 | 2840.01 | 0.00 | 0.00 | 2840.01 | 0.00 |
| Alvarez, Robin, V,11243 | 7164.25 | 3399.99 | 0.00 | 3175.30 | 588.96 |
| King, Adam, M,16932 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Sánchez, Cesar, W,23988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Rodriguez, Manuel, A,24697 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Thompson, Benjamin,19435 | 3457.77 | 0.00 | 0.00 | 3457.77 | 0.00 |
| Anand, Sharon,26208 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Sai, Veronica,16509 | 3258.79 | 0.00 | 0.00 | 2443.35 | 815.44 |
| Raji, Raul, P,21135 | 103.95 | 0.00 | 0.00 | 0.00 | 103.95 |
| Jones, Andrew, C,16594 | 7231.37 | 0.00 | 0.00 | 2443.35 | 4788.02 |
| Rodriguez, Dominic, E,28525 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Gutierrez, Eddie, R,28370 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Xu, Marshall, K,25747 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
Generated 2025-11-06 16:55:47.248 UTC