[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 79 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Sai, Jermaine, G,14934 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Chander, Colin, P,12847 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Zhang, Benjamin, F,12593 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Rubio, Clinton, A,25612 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ramos, Alberto,12239 | 6901.42 | 0.00 | 0.00 | 2071.42 | 4830.00 |
| Rivera, Bryan,18160 | 6914.59 | 0.00 | 0.00 | 2181.56 | 4733.03 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 0.00 | 782.99 | 1764.96 |
| Wang, Alvin,19939 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Torres, Katelyn, L,20804 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Blanco, Joe,25675 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Yang, Jackson,22570 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Jimenez, Janet, P,17112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Liang, Krystal, S,12404 | 5251.71 | 0.00 | 0.00 | 2071.42 | 3180.29 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Munoz, Danny,19355 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Martinez, Jarrod, H,22313 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Madan, Troy,25467 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Mitchell, Fernando,17981 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Tang, Lindsey, C,25308 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
Generated 2026-01-04 08:52:20.724 UTC