[ROOT] dt FactResellerSale PIVOT DimSalesTerritory.Name+'_'+DimCurrency.Name BY OrderDate.Year() SUM SalesAmount TITLE Reseller sales per Sales territory and year (note inclusion of currency for 'safety' reasons)
12 items
| DimSalesTerritory.Name+'_'+DimCurrency.NameId | _SUM | 2020 | 2021 | 2022 | 2023 |
|---|---|---|---|---|---|
| United States, Northwest_US Dollar | 12435076.03 | 389975.27 | 3722215.76 | 3643617.32 | 4679267.68 |
| United States, Central_US Dollar | 7906008.08 | 271958.08 | 2340072.94 | 2818113.45 | 2475863.61 |
| Germany_EURO | 1983987.75 | 0.00 | 0.00 | 434429.07 | 1549558.68 |
| United States, Southwest_US Dollar | 18466458.96 | 399238.59 | 4874819.29 | 7485283.30 | 5707117.78 |
| France_US Dollar | 4116990.29 | 0.00 | 307358.52 | 1647652.84 | 2161978.93 |
| United States, Southeast_US Dollar | 7867415.75 | 441071.66 | 2920395.31 | 2428130.12 | 2077818.66 |
| Canada_Canadian Dollar | 14377925.71 | 432341.98 | 3943747.67 | 5386913.91 | 4614922.15 |
| United States, Northeast_US Dollar | 6932842.17 | 93151.35 | 1830602.57 | 3088887.46 | 1920200.79 |
| United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 263422.69 | 1509044.75 | 2506541.45 |
| France_EURO | 490547.63 | 0.00 | 52952.99 | 179236.61 | 258358.03 |
| Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 184105.59 | 1410229.26 |
| _SUM | 80450596.11 | 2027736.93 | 20255587.74 | 28805414.42 | 29361857.02 |
Generated 2023-12-09 22:29:01.907 UTC