[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1500 > < TAKE 1000
7 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
Ward, Lucas, N,18363 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
Li, Brandon,29339 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
Chen, David,27208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Williams, Sydney, J,15334 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
_SUM | 1806517.50 | 81404.32 | 496236.54 | 389766.13 | 839110.51 |
Generated 2024-09-20 04:03:30.783 UTC