[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 22 > < TAKE 8 >
8 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nath, Clarence,24050 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Lopez, Ronald,17855 | 189.96 | 0.00 | 0.00 | 0.00 | 189.96 |
| Blanco, Rebekah,18149 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Alonso, Albert, M,17645 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Suri, Summer,26219 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Anand, Tonya, A,27141 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Navarro, Armando,19942 | 3034.07 | 699.10 | 0.00 | 0.00 | 2334.97 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
Generated 2025-12-22 07:18:27.514 UTC