[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SKIP 500 < SKIP 1000 > < TAKE 500 >
7 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Harris, Anthony,21447 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
Adams, Katherine, M,23518 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Campbell, Natalie, L,11512 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
_SUM | 1806517.50 | 81404.32 | 496236.54 | 389766.13 | 839110.51 |
Generated 2024-09-20 09:25:20.056 UTC