[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 2049.10 | 3671.27 |
| Shan, Aaron,20730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Fernandez, Chelsea, J,19905 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Rodriguez, Gerald,12216 | 6955.41 | 0.00 | 0.00 | 2071.42 | 4883.99 |
| Mr., Saravan, K.,14974 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Gao, Sandra,12594 | 37.98 | 0.00 | 0.00 | 0.00 | 37.98 |
| Prasad, Frederick,17810 | 87.94 | 0.00 | 0.00 | 0.00 | 87.94 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Andersen, Melvin, D,14770 | 6679.59 | 0.00 | 3578.27 | 0.00 | 3101.32 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Sanchez, Christina, S,14546 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Martin, Jacquelyn, M,17763 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Rubio, Jerome, L,14792 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Yuan, Drew, R,21679 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Williams, Abigail, M,16938 | 3110.05 | 0.00 | 0.00 | 2181.56 | 928.49 |
| Tang, Johnny,15119 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Dominguez, Erik, L,26037 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Torres, Marvin, J,27885 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Raman, Martin,17709 | 78.95 | 0.00 | 0.00 | 0.00 | 78.95 |
| Wu, Jenny, S,23944 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Roberts, Mackenzie,23599 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Raji, Barbara,24019 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Deng, Shawn, C,16590 | 168.95 | 0.00 | 0.00 | 0.00 | 168.95 |
| Diaz, Kathleen, C,28375 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Luo, Bonnie,19337 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
Generated 2025-12-21 19:44:26.642 UTC