[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 53 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| West, Elizabeth,26604 | 4442.16 | 0.00 | 0.00 | 2049.10 | 2393.06 | 0.00 |
| Jones, Blake,23508 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 | 0.00 |
| Russell, Grace, A,23465 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 | 0.00 |
| Bell, Katelyn,21086 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 | 0.00 |
| Rodriguez, Benjamin,20399 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 | 0.00 |
| Thomas, Julia, B,13400 | 4568.50 | 0.00 | 0.00 | 2181.56 | 2386.94 | 0.00 |
| Sara, Kristopher, T,26972 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 | 0.00 |
| Gomez, Philip,28038 | 5985.31 | 0.00 | 3578.27 | 0.00 | 2407.04 | 0.00 |
| Cai, Brittney, L,25898 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 | 0.00 |
| Adams, Isaiah, L,28360 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Scott, Jesse,14453 | 3401.39 | 0.00 | 0.00 | 1000.44 | 2400.95 | 0.00 |
| Gomez, Kristy, M,19237 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Watson, Evan, A,27452 | 4544.47 | 0.00 | 0.00 | 2071.42 | 2473.05 | 0.00 |
| Nelson, Carlos,28977 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 | 0.00 |
Generated 2026-01-04 05:11:24.165 UTC