[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 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 630450.80 | 963884.05 |
Germany_EURO | 1983987.75 | 0.00 | 0.00 | 937674.77 | 1046312.98 |
France_US Dollar | 4116990.29 | 0.00 | 688830.83 | 2044976.79 | 1383182.67 |
United States, Central_US Dollar | 7906008.08 | 753448.07 | 2592877.60 | 2918784.87 | 1640897.54 |
France_EURO | 490547.63 | 0.00 | 80297.21 | 263416.41 | 146834.01 |
United States, Southwest_US Dollar | 18466458.96 | 1406411.77 | 6080107.32 | 7229796.37 | 3750143.50 |
United States, Southeast_US Dollar | 7867415.75 | 1196915.06 | 2837821.21 | 2439554.97 | 1393124.51 |
United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 675761.52 | 1907681.33 | 1695566.04 |
United States, Northwest_US Dollar | 12435076.03 | 1341668.08 | 3690341.12 | 4253007.96 | 3150058.87 |
Canada_Canadian Dollar | 14377925.71 | 1254696.68 | 4592407.95 | 5428443.79 | 3102377.29 |
United States, Northeast_US Dollar | 6932842.17 | 409351.54 | 2423719.56 | 2823145.13 | 1276625.94 |
_SUM | 80450596.11 | 6362491.20 | 23662164.32 | 30876933.19 | 19549007.40 |
Generated 2024-09-08 00:51:39.987 UTC