[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 21 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| McDonald, Harold, J,15051 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Lopez, Courtney,20839 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Raje, Kate,17974 | 2791.46 | 0.00 | 0.00 | 2181.56 | 609.90 |
| Wang, Christy,19498 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Alvarez, Raquel, G,17808 | 159.94 | 0.00 | 0.00 | 0.00 | 159.94 |
| Roberts, Dalton,26387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| Goel, Kathryn,12740 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Nara, Damien, W,26877 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Madan, Troy,25467 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Shan, Grant,26215 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Anderson, Benjamin,20809 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Andersen, Tamara, B,29392 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Zeng, Kelvin, A,26207 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Chow, Jamie,27815 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
| Sanchez, Brian, F,20931 | 3273.17 | 0.00 | 0.00 | 782.99 | 2490.18 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 0.00 | 2181.56 | 2329.98 |
| She, Kurt,26206 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Luo, Terry, H,26850 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
Generated 2025-12-23 16:42:36.530 UTC