[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 9 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Davis, Alyssa, C,13243 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Lin, Ramon,19468 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| James, Taylor, L,23451 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Anand, Roger, L,15054 | 4155.22 | 0.00 | 3578.27 | 0.00 | 576.95 |
| Roberts, Natalie,28176 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Collins, Noah,21298 | 93.46 | 0.00 | 0.00 | 0.00 | 93.46 |
| Cox, Alyssa, F,11083 | 3137.32 | 0.00 | 0.00 | 2394.97 | 742.35 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Martinez, José, A,13748 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Lewis, Cameron, M,11534 | 5919.73 | 0.00 | 3578.27 | 0.00 | 2341.46 |
| Gutierrez, Lee, A,14144 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Davis, Samantha, P,28244 | 6026.31 | 0.00 | 3578.27 | 0.00 | 2448.04 |
| Nelson, Isaiah,14607 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Shawn, L,28398 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
Generated 2025-12-21 23:17:08.917 UTC