[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Zhou, Damien,25776 | 2514.61 | 0.00 | 0.00 | 0.00 | 2514.61 |
| Gonzales, Jessica, A,15610 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Ma, Ronnie, C,17815 | 3123.78 | 0.00 | 0.00 | 2443.35 | 680.43 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Lopez, Raymond, G,27317 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Lopez, Allen, O,13821 | 5940.54 | 0.00 | 3578.27 | 0.00 | 2362.27 |
| Vazquez, Cheryl, A,17948 | 3045.30 | 0.00 | 0.00 | 2443.35 | 601.95 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Andersen, Katrina,19032 | 6938.58 | 0.00 | 0.00 | 2181.56 | 4757.02 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Sara, Bruce,22311 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| Hu, Darryl,24868 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2831.53 | 0.00 |
| Alonso, Albert, M,17645 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Jai, Christine, J,14814 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Rodriguez, Janelle,26887 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Brown, Samuel, M,26999 | 57.98 | 0.00 | 0.00 | 0.00 | 57.98 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Diaz, Armando, P,17978 | 3018.01 | 0.00 | 0.00 | 2181.56 | 836.45 |
| Garcia, Tabitha,27778 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Yang, Omar,12566 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
Generated 2025-12-21 14:53:45.200 UTC