[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Romero, Sheila,20577 | 3080.27 | 0.00 | 782.99 | 0.00 | 2297.28 |
| Jai, Christy, G,26979 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 0.00 | 4737.02 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Gonzalez, Geoffrey,11603 | 6767.14 | 0.00 | 2049.10 | 0.00 | 4718.04 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Garcia, Bob,19186 | 1562.41 | 0.00 | 1000.44 | 0.00 | 561.97 |
| Washington, Cassidy,17701 | 34.47 | 0.00 | 0.00 | 29.48 | 4.99 |
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 2181.56 | 0.00 | 819.46 |
| Rubio, Clinton, A,25612 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ross, Gabrielle, J,19253 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 0.00 | 1000.44 | 636.94 |
| Mr., Shimshoni, Daniel,24705 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
Generated 2025-12-23 07:50:42.912 UTC