[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 17 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Lal, Cassie,12626 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Turner, Charles,24188 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Madan, Phillip,27162 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Watson, Jan, K,13680 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Zheng, Franklin,21044 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhu, Arturo, M,24575 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Natalie, M,20900 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Gao, Dennis,18187 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Kapoor, Brenda, C,20834 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
| Raman, Douglas,24545 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Brooks, Christina, W,22496 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Lal, Ricardo, C,17958 | 2811.52 | 0.00 | 0.00 | 2181.56 | 629.96 |
| Lewis, Katherine,14816 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Madan, Troy,25467 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 0.00 | 4718.04 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Blanco, Gina,28918 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Xu, Omar, R,19279 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Chande, Christy,26214 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Black, Tamara, L,24202 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Evans, Lucas, J,11556 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
Generated 2025-12-24 06:42:24.005 UTC