[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 287 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raje, Jerry, E,21848 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Rowe, Theodore,17794 | 2745.82 | 0.00 | 0.00 | 2181.56 | 564.26 |
| Deng, Edwin, A,17085 | 2986.03 | 0.00 | 0.00 | 2181.56 | 804.47 |
| Lopez, Andre,11434 | 70.46 | 0.00 | 0.00 | 0.00 | 70.46 |
| Sanchez, Brett,12608 | 5689.88 | 0.00 | 0.00 | 2049.10 | 3640.78 |
| Sai, Stanley,13675 | 215.23 | 0.00 | 0.00 | 0.00 | 215.23 |
| Nath, Tonya,24847 | 2552.82 | 0.00 | 0.00 | 0.00 | 2552.82 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Gonzalez, Allen,25572 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
| Ms., Song, Lolan,19073 | 4760.32 | 0.00 | 0.00 | 2443.35 | 2316.97 |
| Lee, Hannah, F,15713 | 37.59 | 0.00 | 0.00 | 0.00 | 37.59 |
| Alvarez, Julio,26205 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Smith, Tabitha,14787 | 163.45 | 0.00 | 0.00 | 0.00 | 163.45 |
| Powell, Gavin, M,28530 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Kelly, Dalton, L,15634 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Zhou, Glenn, A,12326 | 63.98 | 0.00 | 0.00 | 0.00 | 63.98 |
| Chander, Priscilla,16530 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Cox, Taylor,11436 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Williams, Blake,29421 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Rai, Alisha,26848 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Lopez, Samuel, L,26858 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Raman, Holly,25477 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Robinson, Jasmine,26886 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
Generated 2025-12-24 06:28:47.579 UTC