[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 53 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Kapoor, George, L,13676 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Alvarez, Daisy, P,22819 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Morris, Jacqueline, H,29468 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Rodriguez, Dominic, E,28525 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Subram, Carmen, J,29473 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2826.44 | 2342.92 |
| Goel, Calvin, J,17213 | 179.95 | 0.00 | 0.00 | 0.00 | 179.95 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
Generated 2025-12-22 05:25:51.371 UTC