[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 | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Germany_EURO | 1983987.75 | 0.00 | 0.00 | 560152.56 | 1423835.19 |
| United States, Northeast_US Dollar | 6932842.17 | 217471.02 | 1948110.23 | 3120381.51 | 1646879.41 |
| Canada_Canadian Dollar | 14377925.71 | 637982.87 | 4302159.60 | 5499618.44 | 3938164.80 |
| United States, Northwest_US Dollar | 12435076.03 | 618446.37 | 3651580.57 | 4089433.71 | 4075615.38 |
| France_US Dollar | 4116990.29 | 0.00 | 471046.33 | 1682281.83 | 1963662.13 |
| United States, Central_US Dollar | 7906008.08 | 344710.55 | 2513597.80 | 2919999.59 | 2127700.14 |
| United States, Southeast_US Dollar | 7867415.75 | 579274.84 | 3059657.17 | 2440182.63 | 1788301.11 |
| United States, Southwest_US Dollar | 18466458.96 | 795748.40 | 5504162.16 | 7228521.80 | 4938026.60 |
| United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 471783.26 | 1796935.71 | 2010289.92 |
| France_EURO | 490547.63 | 0.00 | 52952.99 | 179236.61 | 258358.03 |
| Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 450884.30 | 1143450.55 |
| _SUM | 80450596.11 | 3193634.05 | 21975050.11 | 29967628.69 | 25314283.26 |
Generated 2025-11-03 22:23:01.866 UTC