[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 45 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Vazquez, Michele,16934 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Xie, Carly, R,13253 | 6774.45 | 0.00 | 0.00 | 2071.42 | 4703.03 |
| Xu, Terrence, L,23743 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yuan, Cedric,15449 | 49.56 | 0.00 | 0.00 | 0.00 | 49.56 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
| Diaz, Neil, C,18181 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Coleman, Austin, V,14865 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Patterson, Emma, J,14941 | 6865.57 | 0.00 | 3578.27 | 0.00 | 3287.30 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Theresa,26824 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Nath, Colleen,24051 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-21 19:44:36.320 UTC