[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Dale, E,21739 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Sanchez, Darren,12502 | 110.46 | 0.00 | 0.00 | 60.47 | 49.99 |
| He, Clarence,16591 | 137.96 | 0.00 | 0.00 | 0.00 | 137.96 |
| Black, Roger, J,28416 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Holt, Brittney,19523 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 0.00 | 3693.28 |
| Rivera, Garrett,22642 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Sharma, Cassie, A,26978 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Andersen, Jerry,20975 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Xu, Karen, E,17115 | 3008.02 | 0.00 | 0.00 | 2181.56 | 826.46 |
| Sanz, Frank, T,20851 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Gutierrez, Casey,12519 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Adams, Rebecca, F,17644 | 3017.33 | 0.00 | 0.00 | 3017.33 | 0.00 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Diaz, Mariah,25465 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Martinez, Evelyn, J,17204 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Raman, Ebony,19348 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Prasad, Sergio, J,19290 | 1605.40 | 0.00 | 0.00 | 1000.44 | 604.96 |
| Xie, Katie, C,19916 | 3354.39 | 0.00 | 0.00 | 1000.44 | 2353.95 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Sanz, Kendra,17753 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Ortega, Gary,11496 | 7013.79 | 0.00 | 3399.99 | 2398.95 | 1214.85 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Lopez, Holly,26876 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
Generated 2025-12-21 08:03:03.761 UTC