[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Wagner, Clayton, L,20922 | 3226.34 | 0.00 | 0.00 | 782.99 | 2443.35 |
| Hayes, Riley,14833 | 6679.60 | 0.00 | 3578.27 | 0.00 | 3101.33 |
| Lee, Hannah, F,15713 | 37.59 | 0.00 | 0.00 | 0.00 | 37.59 |
| Travers, Micheal,26397 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wang, Lisa, J,17205 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Perry, Sydney, C,14963 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanders, Jessica,17650 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Shan, Lindsay,27186 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Chande, Kelsey, K,14846 | 6744.57 | 0.00 | 3578.27 | 0.00 | 3166.30 |
| Rana, Barry,14832 | 5938.24 | 0.00 | 3578.27 | 0.00 | 2359.97 |
| Lal, Nichole, P,25753 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Beck, Christine,20714 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Brooks, Haley, S,17193 | 134.96 | 0.00 | 0.00 | 0.00 | 134.96 |
| Li, Susan,27839 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Wang, Franklin, S,29386 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Carlson, Dana, H,14863 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ma, Leah, H,14553 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nara, Jaime, D,13262 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Deng, Corey,28921 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Martinez, Molly, S,13603 | 133.94 | 0.00 | 0.00 | 0.00 | 133.94 |
| Goel, Willie, T,22656 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 0.00 | 57.95 |
| Edwards, Julia, M,16200 | 96.95 | 0.00 | 0.00 | 0.00 | 96.95 |
| Nara, April, E,25721 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| Raje, Omar, R,12309 | 102.26 | 0.00 | 0.00 | 0.00 | 102.26 |
| Sharma, Grant, R,23966 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
Generated 2025-12-21 22:34:27.733 UTC