[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 45 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mr., Sazanovich, Vadim,14847 | 6725.57 | 0.00 | 3578.27 | 0.00 | 3147.30 |
| Luo, Dale, M,22613 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Malhotra, Raymond, T,13251 | 6844.42 | 0.00 | 0.00 | 2049.10 | 4795.32 |
| Zeng, Kelvin, A,26207 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Li, Sandra,13679 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gutierrez, Audrey,17829 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Schmidt, Michele, M,21545 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Martin, Alexander, K,16402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harris, Jonathan,26220 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gonzalez, Bob, S,24569 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Gomez, Jésus,29401 | 1223.84 | 0.00 | 0.00 | 1223.84 | 0.00 |
| Chandra, Sergio, A,22837 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Guo, Brittney, B,22456 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Jimenez, Jessie,11344 | 8119.81 | 0.00 | 3399.99 | 2297.28 | 2422.54 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Hernandez, Gerald, L,24054 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Romero, Jerome,11337 | 8162.00 | 0.00 | 3374.99 | 2388.96 | 2398.05 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Simpson, Lindsay, E,25746 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Deng, Kelli,22794 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Gutierrez, Walter,25141 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Guo, Stacey,24207 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
Generated 2025-12-23 12:09:03.183 UTC