[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1059 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2071.42 | 3090.31 |
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Holt, Roger,27140 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| Patterson, Margaret, J,13507 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Lopez, Jonathan, D,15103 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Sánchez, Cesar, W,23988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 0.00 | 3648.31 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
Generated 2025-12-24 06:06:09.164 UTC