[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 374 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Li, Laura, O,20933 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Chander, Kelli,26934 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Nara, Drew, A,26944 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
| Butler, Kayla, J,25748 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Muñoz, Kari,19520 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Torres, Deb,11550 | 5241.43 | 0.00 | 2049.10 | 777.34 | 2414.99 |
| Xie, Colleen, C,12133 | 5830.68 | 0.00 | 0.00 | 2071.42 | 3759.26 |
| Raje, Jerry, E,21848 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Deng, Edwin, A,17085 | 2986.03 | 0.00 | 0.00 | 2181.56 | 804.47 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Raji, Barbara,24019 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Nath, Tonya,24847 | 2552.82 | 0.00 | 0.00 | 0.00 | 2552.82 |
| She, Clayton,13785 | 121.83 | 0.00 | 0.00 | 0.00 | 121.83 |
| Yuan, Omar, C,12380 | 5570.22 | 0.00 | 0.00 | 2049.10 | 3521.12 |
| Evans, Isaac, A,17186 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Chandra, Ronald, H,20801 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Hernandez, Francis,21103 | 2506.95 | 0.00 | 0.00 | 782.99 | 1723.96 |
| Malhotra, Michele, A,26896 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Ye, Eugene, E,11609 | 6872.11 | 0.00 | 2049.10 | 0.00 | 4823.01 |
| Vance, Gerald, M,27841 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Goel, Johnny, J,22569 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Ma, Leah, H,14553 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Hernandez, Naomi,25686 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Wu, Ramon, M,27955 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Robinson, Jasmine,26886 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
Generated 2025-12-23 05:07:51.888 UTC