[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 44 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Shawn, E,25501 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Mitchell, Jose, F,24568 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Prasad, Cynthia, L,14808 | 164.20 | 0.00 | 0.00 | 0.00 | 164.20 |
| Jackson, Lucas, A,25481 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Cox, Taylor,11436 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Zeng, Brent, S,21110 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Romero, Jerome,11337 | 8162.00 | 0.00 | 3374.99 | 2388.96 | 2398.05 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Rai, Barbara, J,22451 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
Generated 2025-12-22 05:26:10.026 UTC