[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1125 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhou, Rosa, D,25573 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Malhotra, Ebony,11589 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Rodriguez, Jay, M,28411 | 134.95 | 0.00 | 0.00 | 0.00 | 134.95 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 0.00 | 31.55 |
| Russell, Christian, S,22826 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Perez, Levi,26830 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Luo, Karla, V,11574 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Lu, Brittney, A,12848 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Raje, Maurice,14821 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Mehta, Cynthia,14175 | 108.96 | 0.00 | 0.00 | 0.00 | 108.96 |
| Ye, Dawn,25488 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Yuan, Barbara,21515 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Yuan, Shawn, P,27762 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Moreno, Gary, E,21544 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Martin, Paula, B,21855 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Raman, Rebekah, E,22454 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Luo, Terry, H,26850 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Deng, Kelli,22794 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sai, Tabitha,25741 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Collins, Richard, S,16256 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Gomez, Joe, E,16574 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Serrano, Jill,24026 | 1212.97 | 0.00 | 0.00 | 0.00 | 1212.97 |
| Bryant, Alexandra,12598 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Henderson, Tristan,12224 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Blanco, Mathew, B,12595 | 40.27 | 0.00 | 0.00 | 0.00 | 40.27 |
| Diaz, Mariah,25465 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Romero, Tabitha, M,22416 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
Generated 2025-12-21 22:37:22.262 UTC