[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 79 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhao, Sandra, S,22503 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Ye, Jamie, C,16329 | 3272.09 | 0.00 | 0.00 | 2443.35 | 828.74 |
| Lal, Lacey, L,23751 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 0.00 | 3693.28 |
| Carlson, Lee, S,21079 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Romero, Melinda,12260 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Ye, Omar,21020 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Serrano, Theodore,22631 | 1149.47 | 0.00 | 0.00 | 1149.47 | 0.00 |
| James, Charles,28523 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Dominguez, Julio, E,17094 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Deng, Carly, E,22452 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Scott, Jason,22557 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Malhotra, Roy, P,23220 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ortega, Jésus, L,16542 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Hernandez, Maria,14950 | 6709.59 | 0.00 | 3578.27 | 0.00 | 3131.32 |
| Martin, Albert,26837 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Kumar, Clayton,13841 | 6624.60 | 0.00 | 3578.27 | 751.34 | 2294.99 |
| Garcia, Abigail,14531 | 190.54 | 0.00 | 0.00 | 0.00 | 190.54 |
| Prasad, Rachael, M,22535 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Mehta, Douglas,19258 | 1574.42 | 0.00 | 0.00 | 1000.44 | 573.98 |
| Raji, Tracy,22439 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Sanchez, Christina, S,14546 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Hernandez, Larry,17840 | 228.96 | 0.00 | 0.00 | 0.00 | 228.96 |
| Carlson, Diane, W,21074 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Carlson, Robyn, M,14183 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Dominguez, Lori,12648 | 6817.60 | 0.00 | 0.00 | 2049.10 | 4768.50 |
| Perez, Frederick,16053 | 3752.38 | 0.00 | 0.00 | 2181.56 | 1570.82 |
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 0.00 | 4715.34 |
| Bryant, Marissa, A,28892 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Beck, Carl, M,16311 | 2988.32 | 0.00 | 0.00 | 2988.32 | 0.00 |
| Lal, Jerry, L,27822 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Moreno, Gary, E,21544 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Sharma, Wayne, E,19175 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Cai, Colleen, J,15088 | 5896.19 | 0.00 | 3578.27 | 0.00 | 2317.92 |
| Muñoz, Kari,19520 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Andersen, Katrina,19032 | 6938.58 | 0.00 | 0.00 | 2181.56 | 4757.02 |
| Miller, Jeremiah,17717 | 2840.01 | 0.00 | 0.00 | 2181.56 | 658.45 |
| Romero, Nelson,25728 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Dominguez, Jay, A,21857 | 2487.33 | 0.00 | 0.00 | 2487.33 | 0.00 |
| Xie, Sheena,18041 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Thompson, Benjamin,19435 | 3457.77 | 0.00 | 0.00 | 1000.44 | 2457.33 |
| Coleman, Jessica,13553 | 5603.24 | 0.00 | 0.00 | 2071.42 | 3531.82 |
| Foster, Mya, M,23230 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Shan, Sharon, A,24211 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Mehta, Virginia,13602 | 8376.28 | 0.00 | 3578.27 | 0.00 | 4798.01 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Sandoval, Giraldo, Hierro,22634 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Zhou, Valerie, J,17828 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Blanco, Gina,28918 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Prasad, Rebekah, A,15919 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2026-01-04 08:55:14.615 UTC