[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 32 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rogers, Melissa, J,28415 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Moyer, Felicia, C,28880 | 637.96 | 0.00 | 0.00 | 0.00 | 637.96 |
| Blanco, Gina,28918 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sharma, Barbara, D,22421 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Carlson, Kristine, C,28753 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sai, Jillian,22518 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Chander, Jenny, A,19917 | 3369.41 | 0.00 | 0.00 | 1000.44 | 2368.97 |
| Navarro, Armando,19942 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Deng, Julie,25631 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Stone, Stephanie, S,19060 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 0.00 | 2181.56 | 793.46 |
| She, Raul,19497 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Jai, Kelli,22530 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Howard, Grace, J,20864 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Yang, Jackson,22570 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| He, Claudia, F,24093 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raman, Bryant, S,19048 | 4765.63 | 0.00 | 0.00 | 2443.35 | 2322.28 |
| Clark, Devin,25512 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Chandra, Marie, A,25775 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 0.00 | 2443.35 | 799.48 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Luo, Chad, R,21040 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Navarro, Lee,25659 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Sanchez, Jesse, M,12623 | 5630.21 | 0.00 | 0.00 | 2049.10 | 3581.11 |
| Hernandez, Anne, B,11240 | 7586.23 | 0.00 | 3399.99 | 2369.96 | 1816.28 |
Generated 2026-01-04 08:53:17.204 UTC