[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 | 2022 | 2023 | 2024 | 2025 |
---|---|---|---|---|---|
United States, Northeast_US Dollar | 6932842.17 | 919952.46 | 3097349.63 | 2508532.85 | 407007.23 |
France_EURO | 490547.63 | 0.00 | 107583.18 | 318576.58 | 64387.87 |
Canada_Canadian Dollar | 14377925.71 | 2517183.00 | 5266617.55 | 5613516.36 | 980608.80 |
United States, Southeast_US Dollar | 7867415.75 | 2366169.79 | 2550842.03 | 2418331.69 | 532072.24 |
Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 1246724.44 | 347610.41 |
United States, Northwest_US Dollar | 12435076.03 | 2666955.68 | 3399080.79 | 5287837.48 | 1081202.08 |
United States, Southwest_US Dollar | 18466458.96 | 3033787.41 | 6874455.38 | 7402607.18 | 1155608.99 |
United States, Central_US Dollar | 7906008.08 | 1513474.25 | 2819046.61 | 3025816.40 | 547670.82 |
United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 1163746.02 | 2490635.77 | 624627.10 |
France_US Dollar | 4116990.29 | 0.00 | 1045247.75 | 2411490.06 | 660252.48 |
Germany_EURO | 1983987.75 | 0.00 | 0.00 | 1654201.28 | 329786.47 |
_SUM | 80450596.11 | 13017522.59 | 26323968.94 | 34378270.09 | 6730834.49 |
Generated 2025-04-30 17:38:22.567 UTC