[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1032 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Kumar, Peter,26915 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Zhou, Damien,25776 | 2514.61 | 0.00 | 0.00 | 0.00 | 2514.61 |
| Rowe, Kristi, R,28692 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Guo, Brittney, B,22456 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Sai, Marco,24840 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Guo, Crystal,19379 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Evans, Hunter,25493 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Schmidt, Billy,22434 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Munoz, Meghan, P,27810 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Vance, Joe, L,28877 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| James, Jade, M,26400 | 132.98 | 0.00 | 0.00 | 0.00 | 132.98 |
| Suri, Regina,27800 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Gutierrez, Marie, F,29431 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
Generated 2025-12-24 06:10:00.758 UTC