[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 16 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Turner, Charles,24188 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Rana, Cynthia, L,28397 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 0.00 | 782.99 | 1775.47 |
| Yuan, Kurt,16561 | 3030.03 | 0.00 | 0.00 | 2181.56 | 848.47 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Terry,27305 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Anderson, Samuel, D,14199 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Gomez, Joy, J,12658 | 6863.44 | 0.00 | 0.00 | 2071.42 | 4792.02 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Luo, Arturo,22461 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Carter, Miguel,13776 | 70.57 | 0.00 | 0.00 | 0.00 | 70.57 |
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 0.00 | 1666.79 |
| Anand, Lindsey, K,22592 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Gao, Marshall,25782 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Rogers, Cody, F,26892 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Martinez, Dalton, M,28413 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Tang, Kenneth,28477 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Subram, Cesar, L,11475 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Moreno, Derrick, C,18625 | 2753.82 | 0.00 | 0.00 | 2181.56 | 572.26 |
| Gutierrez, Robin,21104 | 2566.95 | 0.00 | 0.00 | 782.99 | 1783.96 |
| Suarez, Ross, C,27940 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Generated 2025-12-23 11:37:56.525 UTC