[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 55 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Russell, Victoria, D,11317 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Coleman, Oscar, P,18358 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Eduardo,28346 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Chen, Eric, N,15493 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Alexander, Isabella,27555 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Lopez, Molly, C,17647 | 4122.76 | 0.00 | 0.00 | 1792.78 | 2329.98 |
| Nelson, Katelyn,21462 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Andersen, Yolanda,21954 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Reed, Allison,26599 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Clark, Dalton, P,11294 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Rana, Holly,19743 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Gao, Omar,25083 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Walker, Joshua, W,20732 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Zheng, Micah,19234 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
Generated 2025-12-22 09:57:50.843 UTC