[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1156 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hernandez, Kaitlyn, S,25647 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Romero, Kristine, W,16306 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alonso, Briana,21830 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Taylor, Michael,27907 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Chandra, Roy, R,24583 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Dominguez, Natasha,23769 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 0.00 | 1000.44 | 636.94 |
| Ruiz, Pedro,24034 | 1203.46 | 0.00 | 0.00 | 0.00 | 1203.46 |
| Wang, Franklin, S,29386 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Green, Morgan, M,28469 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Rana, Kristina,27847 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Carlson, Dana, H,14863 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Black, Mario, M,27905 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Luo, Karla, V,11574 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Wood, Riley,14705 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Sanchez, Christina, S,14546 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Diaz, Reginald, A,24581 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Tabitha,20147 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Davis, Edward,28896 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chander, Mario,12590 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Evans, Isaac, A,17186 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Goel, Johnny, J,22569 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Goel, Calvin, J,17213 | 179.95 | 0.00 | 0.00 | 0.00 | 179.95 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Deng, Dale,28399 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
Generated 2025-12-24 08:10:27.342 UTC