[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 765 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Malhotra, Barry,20845 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 | 0.00 |
| Flores, Oscar, L,29415 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 | 0.00 |
| Deng, Kathryn,15521 | 3172.95 | 0.00 | 0.00 | 782.99 | 2389.96 | 0.00 |
| Sharma, Russell, A,15637 | 6999.57 | 0.00 | 0.00 | 2181.56 | 4818.01 | 0.00 |
| Clark, Alexandra, R,23271 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 | 0.00 |
| Griffin, Adam,18669 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Williams, Dalton, A,17602 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Torres, Marie,23925 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 | 0.00 |
| Bell, Steven,15534 | 3199.44 | 0.00 | 0.00 | 782.99 | 2416.45 | 0.00 |
| Li, Jose, K,11725 | 123.91 | 0.00 | 0.00 | 0.00 | 123.91 | 0.00 |
| Peterson, Destiny,15537 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 | 0.00 |
| White, Austin, L,12092 | 51.27 | 0.00 | 0.00 | 0.00 | 51.27 | 0.00 |
| Sanchez, Kristi, M,27074 | 4433.17 | 0.00 | 0.00 | 2049.10 | 2384.07 | 0.00 |
| Gonzales, Sarah,13871 | 3060.52 | 0.00 | 0.00 | 2181.56 | 878.96 | 0.00 |
| Arun, Manuel,26697 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 | 0.00 |
Generated 2026-01-04 05:37:04.220 UTC