[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 962 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Bryant, Melanie, L,18670 | 1723.96 | 0.00 | 0.00 | 0.00 | 1723.96 | 0.00 |
| Cooper, Katelyn, C,25159 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 | 0.00 |
| Lee, Ashley, D,23250 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 | 0.00 |
| James, Seth, W,20272 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 | 0.00 |
| Tang, Misty, A,14248 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 | 0.00 |
| Martinez, Kaitlin,15750 | 3087.97 | 0.00 | 0.00 | 782.99 | 2304.98 | 0.00 |
| Morgan, Jade, P,22295 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 | 0.00 |
Generated 2026-01-04 05:39:21.408 UTC