[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 42 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramos, Pedro, P,29416 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| Jai, Shawn, E,25501 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Li, Jeffery,17969 | 3040.31 | 0.00 | 0.00 | 2443.35 | 596.96 |
| Liu, Roger, E,20058 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Wood, Julian, A,18166 | 7200.37 | 0.00 | 0.00 | 2443.35 | 4757.02 |
| Ramos, Diana, J,28733 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 0.00 | 4718.04 |
| Madan, Frederick,16550 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Rai, Colin, W,24573 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
Generated 2026-01-04 04:37:45.752 UTC