[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 906 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Janelle, G,25500 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Liu, Jamie, J,19301 | 1590.42 | 0.00 | 0.00 | 1000.44 | 589.98 |
| Sara, Andre, M,13661 | 5913.24 | 3578.27 | 0.00 | 0.00 | 2334.97 |
| Rai, Kelvin, M,26833 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gomez, Beth, C,13254 | 6801.13 | 0.00 | 0.00 | 2049.10 | 4752.03 |
| Nara, Omar, J,13535 | 59.20 | 0.00 | 0.00 | 0.00 | 59.20 |
| Rodriguez, Janelle,26887 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Luo, Cassie,16452 | 3071.01 | 0.00 | 0.00 | 2181.56 | 889.45 |
| Alvarez, Robin, V,11243 | 7164.25 | 0.00 | 3399.99 | 2364.98 | 1399.28 |
| Patel, Bruce,27165 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Sharma, James, L,21049 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Wang, Kyle,20599 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Pal, Mohamed,20550 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Brown, Nicole,11334 | 8154.02 | 0.00 | 3399.99 | 2334.97 | 2419.06 |
Generated 2025-12-23 11:39:49.236 UTC