[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cai, Barbara, A,22227 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Perez, Sophia,20327 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nelson, Jeremy, K,26839 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Lin, Arturo,13439 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Ramirez, Gabriella, M,13146 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Henderson, Vanessa,13538 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Kelly, Riley,22279 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Vazquez, Melody,20747 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Moore, Ethan, M,13151 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Zhang, Luke,18862 | 2354.47 | 0.00 | 0.00 | 0.00 | 2354.47 |
| Arun, Bruce, T,21037 | 2438.28 | 0.00 | 0.00 | 782.99 | 1655.29 |
| Cook, Kimberly, R,28190 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Lewis, Emma,22243 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Brooks, Destiny, S,18105 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-23 07:50:45.943 UTC