[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 62 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Jai, Damien,14806 | 242.94 | 0.00 | 0.00 | 0.00 | 242.94 |
| Jai, Casey, C,22560 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Subram, Cesar, L,11475 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Cooper, Kimberly, J,22457 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gomez, Jay,26232 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ruiz, Derrick, C,12634 | 6787.76 | 0.00 | 0.00 | 2071.42 | 4716.34 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Rogers, Cody, F,26892 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Xie, Alejandro,25781 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Li, Darryl, T,24549 | 2514.93 | 0.00 | 0.00 | 0.00 | 2514.93 |
| Raje, Andres,20710 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Rubio, Victor, S,16193 | 90.47 | 0.00 | 0.00 | 0.00 | 90.47 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| Brooks, Savannah, R,24558 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Ortega, Kendra,25592 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kennedy, Kelsey, M,23984 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanz, Juan, R,14983 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 0.00 | 3106.31 |
| Ramos, Anne, R,11351 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
Generated 2025-12-23 07:28:15.678 UTC