[ROOT] dt FactResellerSale PIVOT DimSalesTerritory.Name+'_'+DimCurrency.Name BY OrderDate.Year() SUM SalesAmount
12 items
DimSalesTerritory.Name+'_'+DimCurrency.NameId | _SUM | 2022 | 2023 | 2024 | 2025 |
---|---|---|---|---|---|
Germany_EURO | 1983987.75 | 0.00 | 0.00 | 1355299.02 | 628688.73 |
United States, Northwest_US Dollar | 12435076.03 | 2304784.71 | 3456198.74 | 4770748.89 | 1903343.69 |
France_US Dollar | 4116990.29 | 0.00 | 938951.92 | 2398708.75 | 779329.62 |
Canada_Canadian Dollar | 14377925.71 | 1953770.69 | 4996950.50 | 5596456.79 | 1830747.73 |
United States, Southwest_US Dollar | 18466458.96 | 2511592.37 | 6563211.88 | 7199250.66 | 2192404.05 |
United States, Northeast_US Dollar | 6932842.17 | 756233.55 | 2773503.89 | 2627292.68 | 775812.05 |
France_EURO | 490547.63 | 0.00 | 95778.96 | 306579.77 | 88188.90 |
Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 987311.90 | 607022.95 |
United States, Central_US Dollar | 7906008.08 | 1200662.20 | 2758257.05 | 2991457.02 | 955631.81 |
United States, Southeast_US Dollar | 7867415.75 | 1952298.32 | 2650239.61 | 2395317.91 | 869559.91 |
United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 999823.18 | 2233702.72 | 1045482.99 |
_SUM | 80450596.11 | 10679341.84 | 25232915.73 | 32862126.11 | 11676212.43 |
Generated 2025-06-14 07:13:27.040 UTC