[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 |
|---|---|---|---|---|---|
| France_EURO | 490547.63 | 0.00 | 117906.64 | 372640.99 | 0.00 |
| United States, Northeast_US Dollar | 6932842.17 | 1061252.16 | 3297061.30 | 2333854.46 | 240674.25 |
| United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 1275963.61 | 2577066.20 | 425979.08 |
| Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 1362792.79 | 231542.06 |
| Canada_Canadian Dollar | 14377925.71 | 2901825.66 | 5349656.10 | 5541247.02 | 585196.93 |
| United States, Northwest_US Dollar | 12435076.03 | 3109325.27 | 3437341.85 | 5371556.46 | 516852.45 |
| Germany_EURO | 1983987.75 | 0.00 | 0.00 | 1847530.56 | 136457.19 |
| United States, Southeast_US Dollar | 7867415.75 | 2740833.13 | 2389385.12 | 2467593.05 | 269604.45 |
| United States, Southwest_US Dollar | 18466458.96 | 3623459.78 | 7078663.56 | 7171707.76 | 592627.86 |
| United States, Central_US Dollar | 7906008.08 | 1849943.33 | 2766569.13 | 2991431.99 | 298063.63 |
| France_US Dollar | 4116990.29 | 0.00 | 1223057.90 | 2774696.12 | 119236.27 |
| _SUM | 80450596.11 | 15286639.33 | 26935605.21 | 34812117.40 | 3416234.17 |
Generated 2023-03-20 10:36:04.980 UTC