[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 14 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Srini, Carla,27506 | 33.43 | 0.00 | 0.00 | 0.00 | 33.43 | 0.00 |
| Johnson, Natalie,23816 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 | 0.00 |
| Guo, Kristen, A,12033 | 5949.23 | 0.00 | 3578.27 | 0.00 | 2370.96 | 0.00 |
| Alexander, Isabella,27555 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 | 0.00 |
| Moore, Alexis,28646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Lal, Kathryn, H,12831 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Sharma, Tasha, M,20942 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Alexander, Samantha, N,17624 | 2357.28 | 0.00 | 0.00 | 0.00 | 2357.28 | 0.00 |
| Scott, Chloe, A,27078 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 | 0.00 |
| She, Tony, M,14269 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 | 0.00 |
| Watson, Paige,28081 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 | 0.00 |
| Lal, Adam,13877 | 3030.03 | 0.00 | 0.00 | 2181.56 | 848.47 | 0.00 |
Generated 2026-01-04 05:19:50.945 UTC