[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2390 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sara, Jermaine, A,25602 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Wood, Caroline,25203 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Anderson, Edward, L,26328 | 4518.15 | 0.00 | 0.00 | 2049.10 | 2469.05 |
| Rai, Gilbert, B,19384 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Yang, Gilbert, M,19370 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hughes, Jeremiah, C,19161 | 584.90 | 0.00 | 0.00 | 0.00 | 584.90 |
| Bradley, Desiree, J,20582 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
| James, Melanie, V,17546 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Clark, Victoria,24815 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Green, Aaron, R,24953 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Chander, Dawn,13818 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Ramos, Kellie, M,28472 | 750.30 | 0.00 | 0.00 | 0.00 | 750.30 |
| Nath, Kathryn,28632 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Johnson, Rachel,18419 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cooper, Bryce, D,22096 | 133.47 | 0.00 | 0.00 | 0.00 | 133.47 |
Generated 2025-12-17 20:36:39.031 UTC