[ROOT] dt FactResellerSale PIVOT DimSalesTerritory.Name+'_'+DimCurrency.Name BY OrderDate.Year() SUM SalesAmount TITLE Reseller sales pr Sales territory country and year (note inclusion of currency for 'safety' reasons)
12 items
DimSalesTerritory.Name+'_'+DimCurrency.NameId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Canada_Canadian Dollar | 14377925.71 | 1677139.49 | 4919709.80 | 5627529.64 | 2153546.78 |
United States, Southwest_US Dollar | 18466458.96 | 2009761.09 | 6425445.22 | 7328351.69 | 2702900.96 |
Germany_EURO | 1983987.75 | 0.00 | 0.00 | 1211505.31 | 772482.44 |
United States, Northeast_US Dollar | 6932842.17 | 626625.95 | 2625451.48 | 2764296.23 | 916468.51 |
France_EURO | 490547.63 | 0.00 | 85099.55 | 269493.47 | 135954.61 |
United States, Northwest_US Dollar | 12435076.03 | 1824275.70 | 3534700.73 | 4729740.95 | 2346358.65 |
France_US Dollar | 4116990.29 | 0.00 | 806539.97 | 2110608.92 | 1199841.40 |
Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 910810.31 | 683524.54 |
United States, Southeast_US Dollar | 7867415.75 | 1640389.96 | 2748786.24 | 2419921.57 | 1058317.98 |
United States, Central_US Dollar | 7906008.08 | 1000360.55 | 2724576.48 | 2971485.28 | 1209585.77 |
United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 878548.74 | 2203929.38 | 1196530.77 |
_SUM | 80450596.11 | 8778552.74 | 24748858.21 | 32547672.75 | 14375512.41 |
Generated 2024-07-27 06:34:28.745 UTC