[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 |
|---|---|---|---|---|---|
| Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 506225.74 | 1088109.11 |
| Germany_EURO | 1983987.75 | 0.00 | 0.00 | 752364.15 | 1231623.60 |
| United States, Northwest_US Dollar | 12435076.03 | 783033.97 | 3734997.13 | 4170871.24 | 3746173.69 |
| France_EURO | 490547.63 | 0.00 | 71668.30 | 172069.32 | 246810.01 |
| Canada_Canadian Dollar | 14377925.71 | 872890.13 | 4463833.08 | 5505405.28 | 3535797.22 |
| United States, Southeast_US Dollar | 7867415.75 | 749819.57 | 3035398.87 | 2455403.53 | 1626793.78 |
| United States, Southwest_US Dollar | 18466458.96 | 945262.34 | 5759077.39 | 7443778.10 | 4318341.13 |
| United States, Central_US Dollar | 7906008.08 | 404685.92 | 2658059.86 | 2878119.75 | 1965142.55 |
| United States, Northeast_US Dollar | 6932842.17 | 282663.25 | 2166212.07 | 3026161.79 | 1457805.06 |
| United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 535116.13 | 1849696.91 | 1894195.85 |
| France_US Dollar | 4116990.29 | 0.00 | 508120.79 | 1687493.76 | 1921375.74 |
| _SUM | 80450596.11 | 4038355.18 | 22932483.62 | 30447589.57 | 23032167.74 |
Generated 2024-10-13 01:41:04.980 UTC