[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1157 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sai, Gerald, L,27894 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rodriguez, Marie, L,17960 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Gao, Claudia,13690 | 7162.08 | 0.00 | 3578.27 | 0.00 | 3583.81 |
| Black, Willie,18172 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Nara, Clarence, G,20054 | 3338.04 | 0.00 | 699.10 | 0.00 | 2638.94 |
| Kumar, Clayton,13841 | 6624.60 | 0.00 | 3578.27 | 751.34 | 2294.99 |
| Walker, Sydney, A,19047 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| McDonald, Jenny,16543 | 53.96 | 0.00 | 0.00 | 0.00 | 53.96 |
| Arun, Heidi, Z,20149 | 3165.42 | 0.00 | 699.10 | 0.00 | 2466.32 |
| Alvarez, Danny,13820 | 5908.26 | 0.00 | 3578.27 | 0.00 | 2329.99 |
| Jimenez, Lawrence, B,21068 | 81.45 | 0.00 | 0.00 | 0.00 | 81.45 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Malhotra, Jay,14159 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Thomas, Jose, A,26960 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Ye, Sandra,24689 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Wood, Riley,14705 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Garcia, Ryan, J,15692 | 8392.30 | 0.00 | 3578.27 | 0.00 | 4814.03 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Navarro, Shannon, R,15106 | 8421.28 | 0.00 | 3578.27 | 0.00 | 4843.01 |
| Hayes, Riley,14833 | 6679.60 | 0.00 | 3578.27 | 0.00 | 3101.33 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Ward, Alex, I,14542 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Rana, Barry,14832 | 5938.24 | 0.00 | 3578.27 | 0.00 | 2359.97 |
| Raman, Darren, K,22315 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhao, Dennis,20173 | 3181.33 | 0.00 | 699.10 | 0.00 | 2482.23 |
Generated 2025-12-23 12:14:56.755 UTC