[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1064 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wagner, Deb, R,24030 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Xie, Melvin,28426 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Zhu, Stacey, E,22636 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Gomez, Neil,29426 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Zhao, Omar,27927 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Alvarez, Neil, C,22467 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Goel, Kathryn,12740 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Zhou, Damien,25776 | 2514.61 | 0.00 | 0.00 | 0.00 | 2514.61 |
| Long, Kelly, G,25545 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Schmidt, Billy,22434 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Kapoor, Nancy, L,18024 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Mr., Shridhar, Shish,25761 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Navarro, Audrey, S,26937 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Lopez, Harold,26913 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Hu, Candice,27818 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Morgan, Arianna,18155 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Martinez, Richard, J,14986 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zhang, Alvin,19082 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alonso, Hector, L,12134 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Yuan, Clarence, D,24047 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Allen, Miguel, C,11385 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Vance, Erick,28742 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Jackson, Lucas, A,25481 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Zhao, Amy, C,26416 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Guo, Clayton, J,22302 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Navarro, Wendy, C,20881 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Anderson, Kaitlyn, H,24101 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Xie, Edwin, E,28879 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Carlson, Desiree, V,14864 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Zheng, Nuan,13604 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Rana, Carolyn,21829 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Foster, Mary,24112 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rivera, Dalton, E,28366 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Pal, Karl, S,19187 | 147.28 | 0.00 | 0.00 | 0.00 | 147.28 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Guo, Brittney, B,22456 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Navarro, Micheal,23625 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Zheng, Mandy,24721 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Gutierrez, Audrey,17829 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Madan, Joel, C,17887 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Deng, Dustin, F,11422 | 7075.27 | 0.00 | 3399.99 | 2334.98 | 1340.30 |
| Raje, Christine, W,17203 | 6952.53 | 0.00 | 0.00 | 2181.56 | 4770.97 |
| Carlson, Craig, G,17218 | 6907.56 | 0.00 | 0.00 | 2181.56 | 4726.00 |
| 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 |
| Butler, Kayla, J,25748 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Muñoz, Kari,19520 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Torres, Deb,11550 | 5241.43 | 0.00 | 2049.10 | 777.34 | 2414.99 |
| Carter, Miguel,13776 | 70.57 | 0.00 | 0.00 | 0.00 | 70.57 |
| Xie, Colleen, C,12133 | 5830.68 | 0.00 | 0.00 | 2071.42 | 3759.26 |
| Raje, Jerry, E,21848 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Deng, Edwin, A,17085 | 2986.03 | 0.00 | 0.00 | 2181.56 | 804.47 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Raji, Barbara,24019 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
Generated 2025-12-23 14:11:03.811 UTC