[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 301 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Holt, Brittney,19523 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Johnson, Lucas,13509 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Morgan, Angel, G,24835 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| McDonald, Deborah, R,16275 | 3282.83 | 0.00 | 0.00 | 2443.35 | 839.48 |
| Fernandez, Jillian, K,12599 | 5649.21 | 0.00 | 0.00 | 2071.42 | 3577.79 |
| Deng, Yolanda,28427 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alonso, Albert, M,17645 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zeng, Alan, M,22321 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Lin, Marshall,16822 | 7176.38 | 0.00 | 0.00 | 2443.35 | 4733.03 |
| Romero, Neil,28424 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Gonzalez, Preston, L,14156 | 229.57 | 0.00 | 0.00 | 0.00 | 229.57 |
Generated 2026-01-04 05:48:32.888 UTC