[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 62 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Romero, Joe, J,17943 | 2781.54 | 0.00 | 0.00 | 2181.56 | 599.98 |
| Lal, Misty, L,22385 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alonso, Hector, L,12134 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Malhotra, Raymond, T,13251 | 6844.42 | 0.00 | 0.00 | 2049.10 | 4795.32 |
| She, Kelvin, T,27002 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Washington, Isabella,20880 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Chapman, Pedro,17785 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Sai, Marco,24840 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Xu, Brendan, L,14937 | 6652.89 | 0.00 | 3578.27 | 0.00 | 3074.62 |
| Martinez, George, L,20570 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
Generated 2025-12-22 00:22:47.822 UTC