[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 |
|---|---|---|---|---|---|
| Germany_EURO | 1983987.75 | 0.00 | 0.00 | 180040.51 | 1803947.24 |
| France_US Dollar | 4116990.29 | 0.00 | 55057.86 | 1286955.45 | 2774976.98 |
| United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 80686.69 | 1478290.06 | 2720032.14 |
| France_EURO | 490547.63 | 0.00 | 42438.45 | 99034.26 | 349074.92 |
| Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 49824.66 | 1544510.19 |
| United States, Northwest_US Dollar | 12435076.03 | 93905.59 | 3466302.95 | 3466033.30 | 5408834.19 |
| United States, Southeast_US Dollar | 7867415.75 | 139164.14 | 2902228.47 | 2473607.44 | 2352415.70 |
| Canada_Canadian Dollar | 14377925.71 | 115360.89 | 3602561.64 | 5478100.78 | 5181902.40 |
| United States, Southwest_US Dollar | 18466458.96 | 100056.47 | 4285401.02 | 7703502.19 | 6377499.28 |
| United States, Central_US Dollar | 7906008.08 | 19243.05 | 2276760.23 | 2755563.30 | 2854441.50 |
| United States, Northeast_US Dollar | 6932842.17 | 21598.42 | 1481367.26 | 3222682.90 | 2207193.59 |
| _SUM | 80450596.11 | 489328.56 | 18192804.57 | 28193634.85 | 33574828.13 |
Generated 2025-01-18 17:56:07.156 UTC