[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 38 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gao, Colleen,15108 | 210.54 | 0.00 | 0.00 | 0.00 | 210.54 |
| Watson, Bryce,27799 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Madan, Phillip,27162 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| She, Cara, H,22646 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lal, Tony,28515 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Yuan, Clarence, D,24047 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Blanco, Gina,28918 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Powell, Gavin, M,28530 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ramos, Kari, D,24702 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Rodriguez, Noah, J,22325 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ye, Micah, A,20952 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Moreno, Francis, A,26962 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rivera, Garrett,22642 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Jai, Terrence,27956 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Perry, Hailey, G,20721 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Wang, Alvin,19939 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Martinez, Deanna,17202 | 6974.06 | 0.00 | 0.00 | 2181.56 | 4792.50 |
Generated 2025-12-22 01:08:34.602 UTC