[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 96 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chandra, Holly,17771 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Alonso, Carolyn,27902 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ward, Janet,26975 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Jimenez, Theodore, M,27254 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Alonso, Clinton,23759 | 2475.95 | 0.00 | 0.00 | 2475.95 | 0.00 |
| Kelly, Kaitlyn, G,18380 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Torres, Jerome, N,13205 | 4803.32 | 0.00 | 2443.35 | 0.00 | 2359.97 |
| Martin, Max, A,16030 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Rana, Dominic, B,26925 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Alvarez, Javier, L,11140 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Torres, Charles, S,11644 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Gill, Tabitha, L,14254 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
Generated 2025-12-24 05:51:25.295 UTC