[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1048 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Ross, Taylor, S,26545 | 2822.76 | 0.00 | 0.00 | 2071.42 | 751.34 | 0.00 |
| Gray, Michelle,26600 | 2800.44 | 0.00 | 0.00 | 2049.10 | 751.34 | 0.00 |
| Bryant, Cameron,15371 | 3178.95 | 0.00 | 0.00 | 782.99 | 2395.96 | 0.00 |
| Perez, Connor,15369 | 3127.95 | 0.00 | 0.00 | 782.99 | 2344.96 | 0.00 |
| Moreno, Ebony, J,16409 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 | 0.00 |
| Patterson, Mariah, F,26581 | 2822.76 | 0.00 | 0.00 | 2071.42 | 751.34 | 0.00 |
| Wilson, Arthur,18762 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 | 0.00 |
| Cooper, Gabriella, L,18596 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 | 0.00 |
| Vance, Ronald,25459 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 | 0.00 |
| Nelson, Jesse, M,26793 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 | 0.00 |
| Stone, Gavin, T,16718 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 | 0.00 |
| Barnes, Angela, M,26532 | 4469.47 | 0.00 | 0.00 | 2071.42 | 2398.05 | 0.00 |
| Alvarez, Wendy, V,12129 | 8557.41 | 0.00 | 0.00 | 2071.42 | 6485.99 | 0.00 |
| Xu, Mitchell, J,12218 | 4472.37 | 0.00 | 0.00 | 2071.42 | 2400.95 | 0.00 |
Generated 2026-01-04 05:25:42.296 UTC