[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Ross, Gabriel, K,16314 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Gill, Jill, J,26870 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Xu, Karen, E,17115 | 3008.02 | 0.00 | 0.00 | 2181.56 | 826.46 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lopez, Emmanuel, R,12559 | 5633.91 | 0.00 | 0.00 | 2049.10 | 3584.81 |
| Nath, Casey,11616 | 5253.65 | 0.00 | 2071.42 | 784.28 | 2397.95 |
| Vazquez, Meghan, W,15047 | 6669.57 | 0.00 | 3578.27 | 0.00 | 3091.30 |
| Dominguez, Teresa, C,20963 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Lopez, Morgan, F,19466 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Sharma, Latoya,19260 | 1592.71 | 0.00 | 0.00 | 1000.44 | 592.27 |
| Davis, Edward,28896 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Zhang, Jake,22616 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Johnsen, Jerome,28367 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Suri, Terrance, C,21046 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Carlson, Melinda,20921 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Anand, Nichole,12508 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Torres, Marvin, J,27885 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Xu, Ronnie,17892 | 2787.51 | 0.00 | 0.00 | 2181.56 | 605.95 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Deng, Shawn, C,16590 | 168.95 | 0.00 | 0.00 | 0.00 | 168.95 |
| Hall, Sydney, T,17880 | 39.55 | 0.00 | 0.00 | 0.00 | 39.55 |
| Parker, Eric, H,27130 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Raman, George, M,26359 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kumar, Carl,12743 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Romero, Gerald, K,19322 | 1565.43 | 0.00 | 0.00 | 1000.44 | 564.99 |
Generated 2025-12-22 02:00:03.576 UTC