[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chander, Sheena, L,16308 | 4551.52 | 0.00 | 2181.56 | 0.00 | 2369.96 |
| Lal, Misty, L,22385 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Ramos, Diana, J,28733 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Ross, Hailey, C,13612 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Martin, Gloria, A,12325 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Wright, Elijah, I,25577 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Tang, Brad,25489 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Schmidt, Marc,12808 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Black, Roger, J,28416 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Yang, Omar,12566 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Sanz, Marie,13600 | 8460.25 | 3578.27 | 0.00 | 0.00 | 4881.98 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Moreno, Albert,12402 | 5218.40 | 0.00 | 0.00 | 2049.10 | 3169.30 |
| Suri, Tammy,24031 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Malhotra, Roy, P,23220 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 2429.46 | 1263.82 |
| Raje, Omar, R,12309 | 102.26 | 0.00 | 0.00 | 23.78 | 78.48 |
| Fernandez, Kari,13788 | 200.81 | 0.00 | 0.00 | 0.00 | 200.81 |
| Shan, Aaron,20730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Nara, Roger,26928 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Suri, Clifford,19369 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Suri, Tabitha,27957 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sanchez, Morgan, J,12262 | 119.45 | 0.00 | 0.00 | 60.47 | 58.98 |
| Perez, Frederick,16053 | 3752.38 | 0.00 | 2181.56 | 0.00 | 1570.82 |
| Patterson, Emma, J,14941 | 6865.57 | 0.00 | 3578.27 | 0.00 | 3287.30 |
| Sánchez, Cesar, W,23988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Kelly, Marcus, A,25699 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Sharma, Barbara, D,22421 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Huang, Todd,12463 | 5202.22 | 0.00 | 0.00 | 2071.42 | 3130.80 |
| Luo, Terry, H,26850 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Cai, Jamie, S,13505 | 127.93 | 0.00 | 0.00 | 0.00 | 127.93 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| 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 |
| Taylor, Charles,13792 | 7216.08 | 3578.27 | 0.00 | 0.00 | 3637.81 |
| Wang, Lisa, J,17205 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Wu, Jake, E,22446 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Rodriguez, Bruce,28473 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Garcia, Carla,14172 | 75.74 | 0.00 | 0.00 | 0.00 | 75.74 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Torres, Audrey,16571 | 52.92 | 0.00 | 0.00 | 0.00 | 52.92 |
| Lopez, Edward, L,26931 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Lopez, Emmanuel, R,12559 | 5633.91 | 0.00 | 0.00 | 2049.10 | 3584.81 |
| Munoz, Rodney,12836 | 68.46 | 0.00 | 0.00 | 0.00 | 68.46 |
| Martinez, Molly, S,13603 | 133.94 | 0.00 | 0.00 | 83.97 | 49.97 |
| Serrano, Jill,24026 | 1212.97 | 0.00 | 0.00 | 0.00 | 1212.97 |
| Ye, Jamie, C,16329 | 3272.09 | 0.00 | 2443.35 | 0.00 | 828.74 |
| Washington, Cassidy,17701 | 34.47 | 0.00 | 0.00 | 29.48 | 4.99 |
| Lu, Rafael, J,22869 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rana, Martin,24213 | 1214.46 | 0.00 | 0.00 | 0.00 | 1214.46 |
| Nara, Casey, E,17812 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Raje, Kate,17974 | 2791.46 | 0.00 | 0.00 | 2181.56 | 609.90 |
| Xu, Karen, E,17115 | 3008.02 | 0.00 | 0.00 | 2181.56 | 826.46 |
| Sai, Marie, A,24582 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Yang, Bianca, E,28732 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Perez, Bruce, R,16935 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Ruiz, Nelson,23638 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Reed, Cole,12603 | 117.45 | 0.00 | 0.00 | 0.00 | 117.45 |
| Deng, Edwin, A,17085 | 2986.03 | 0.00 | 0.00 | 2181.56 | 804.47 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Garcia, Douglas,24860 | 2520.31 | 0.00 | 0.00 | 0.00 | 2520.31 |
| Sun, Alejandro, B,23923 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Nath, Tonya,24847 | 2552.82 | 0.00 | 0.00 | 0.00 | 2552.82 |
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Thompson, Morgan, Q,24011 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Yuan, Omar, C,12380 | 5570.22 | 0.00 | 0.00 | 2049.10 | 3521.12 |
| Evans, Isaac, A,17186 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Cox, Taylor,11436 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Rai, Alisha,26848 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Mitchell, Fernando,17981 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 2359.46 | 2393.06 |
| Raman, Holly,25477 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Perez, Dominic, A,23940 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Robinson, Jasmine,26886 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Ma, Ronnie, C,17815 | 3123.78 | 0.00 | 0.00 | 2443.35 | 680.43 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Zhang, Franklin, L,12597 | 53.21 | 0.00 | 0.00 | 0.00 | 53.21 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Andersen, Clayton,15631 | 5122.39 | 0.00 | 3578.27 | 801.77 | 742.35 |
| Vance, Erick,28742 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Raje, Roger, E,11596 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 94.97 | 68.97 |
| Alvarez, Kristi,12303 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Diaz, Jaime, A,17795 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Zhang, Colleen, L,16562 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Anand, Sharon,26208 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Ruiz, Ruben, A,20055 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Wagner, Deb, R,24030 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Richardson, Megan, M,15662 | 5253.07 | 0.00 | 3578.27 | 0.00 | 1674.80 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Ye, Kristen, D,12486 | 5652.40 | 0.00 | 0.00 | 2049.10 | 3603.30 |
| Kumar, Raul, B,12857 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Henderson, Anna,24857 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Audrey, S,26937 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Ross, Ryan,16428 | 3021.02 | 0.00 | 2181.56 | 0.00 | 839.46 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Malhotra, Johnathan,17723 | 83.94 | 0.00 | 0.00 | 64.97 | 18.97 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Lin, Alejandro, L,12563 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Zhang, Alvin,19082 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Tang, Gilbert, D,21533 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Liang, Jeffery,15711 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Gray, Natalie, L,14165 | 5910.55 | 0.00 | 3578.27 | 0.00 | 2332.28 |
| King, Jack, H,17702 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Gonzalez, Geoffrey,11603 | 6767.14 | 0.00 | 2049.10 | 2319.99 | 2398.05 |
| Black, Nicolas,23945 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jimenez, Rodney, R,12476 | 73.77 | 0.00 | 0.00 | 0.00 | 73.77 |
| Rana, Allen, D,19036 | 4763.34 | 0.00 | 0.00 | 2443.35 | 2319.99 |
Generated 2025-11-02 00:40:25.662 UTC