[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 1500 > < TAKE 500 >
7 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
Bell, Garrett, J,14265 | 161.23 | 0.00 | 0.00 | 0.00 | 161.23 |
Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Perez, Sydney, C,22117 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
White, Christopher, R,26049 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
Torres, Xavier,16840 | 176.95 | 0.00 | 0.00 | 0.00 | 176.95 |
Generated 2024-09-20 05:47:29.351 UTC