[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Rubio, Jerome, L,14792 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Lopez, Cindy, L,27137 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Blanco, Clinton, J,14195 | 8316.29 | 0.00 | 3578.27 | 0.00 | 4738.02 |
| Hu, Jake, L,24576 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Lal, Cassie,12626 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Lu, Clayton, L,23613 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Gomez, Kristine, E,18627 | 3027.32 | 0.00 | 0.00 | 2443.35 | 583.97 |
| Cai, Lacey, L,12733 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Pal, Karl, S,19187 | 147.28 | 0.00 | 0.00 | 0.00 | 147.28 |
| Raman, Joel,16317 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
Generated 2025-12-24 05:48:59.987 UTC