[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1201 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chapman, Pedro,17785 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Sun, Omar, D,25783 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vance, Joe, L,28877 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Saunders, Cynthia,24537 | 2511.32 | 0.00 | 0.00 | 0.00 | 2511.32 |
| Brooks, Sara, A,12288 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Goel, Tasha, R,19478 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raje, Roger, E,11596 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Sun, Autumn, A,22564 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Hall, Sydney, T,17880 | 39.55 | 0.00 | 0.00 | 0.00 | 39.55 |
| Gonzalez, Stefanie, J,28709 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Sai, Tabitha,25741 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| King, Wyatt,22671 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Deng, Brendan,25726 | 663.44 | 0.00 | 0.00 | 0.00 | 663.44 |
| Brooks, Christina, W,22496 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Carlson, Gary, R,24115 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Johnsen, Jerome,28367 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Xie, Melvin,28426 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gomez, Neil,29426 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Malhotra, Frederick,17951 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Sanz, Joanna, L,25732 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Rivera, Chase,28511 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Zhu, Laura, M,29439 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Pal, Kristin, E,26956 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Vazquez, Melinda, C,22553 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Yuan, Kelvin, L,25692 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Sandoval, Giraldo, Hierro,22634 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Barnes, Alexis, J,23935 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anand, Alejandro, R,28899 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Mitchell, Jose, F,24568 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hu, Jake, L,24576 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
Generated 2025-12-23 14:09:46.426 UTC