[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
---|---|---|---|---|---|---|---|
2022-06 | 87758.48 | 32343.69 | 3578.27 | 7156.54 | 3399.99 | 11433.91 | 29846.08 |
2023-09 | 370788.66 | 138594.97 | 13575.83 | 0.00 | 0.00 | 51798.64 | 166819.22 |
2022-09 | 430914.80 | 179866.12 | 10734.81 | 15012.18 | 33399.35 | 56431.43 | 135470.91 |
2024-03 | 492531.70 | 201970.51 | 24782.47 | 0.00 | 0.00 | 63835.91 | 201942.81 |
2022-11 | 567949.69 | 214974.96 | 32725.25 | 46453.49 | 43256.78 | 26966.91 | 203572.30 |
2024-12 | 1581502.08 | 352620.28 | 135602.67 | 0.00 | 0.00 | 203146.97 | 890132.16 |
2023-01 | 631569.15 | 247304.63 | 46860.05 | 0.00 | 0.00 | 71857.94 | 265546.53 |
2023-02 | 564252.43 | 168845.26 | 46110.95 | 0.00 | 0.00 | 36442.78 | 312853.44 |
2023-05 | 669907.47 | 215050.20 | 54309.13 | 0.00 | 0.00 | 39296.95 | 361251.19 |
2024-01 | 477374.05 | 194614.84 | 20407.94 | 0.00 | 0.00 | 60789.39 | 201561.88 |
2024-04 | 536900.71 | 202370.96 | 20423.70 | 0.00 | 0.00 | 56524.75 | 257581.30 |
2024-07 | 878525.55 | 238518.24 | 46223.09 | 0.00 | 0.00 | 132961.28 | 460822.94 |
2024-08 | 894833.44 | 212787.57 | 63935.16 | 0.00 | 0.00 | 131575.13 | 486535.58 |
2025-04 | 1665736.98 | 438994.71 | 107420.23 | 0.00 | 0.00 | 205997.37 | 913324.67 |
2022-07 | 498436.08 | 245778.15 | 21965.44 | 35604.42 | 43930.88 | 30341.90 | 120815.29 |
2022-10 | 555555.63 | 224436.81 | 12628.83 | 54804.95 | 11433.91 | 48436.53 | 203814.60 |
2022-12 | 711489.29 | 246640.06 | 51087.42 | 37994.26 | 26941.91 | 68240.65 | 280584.99 |
2023-03 | 621217.42 | 224565.09 | 39157.69 | 0.00 | 0.00 | 38979.41 | 318515.23 |
2023-04 | 684226.80 | 225874.27 | 64205.58 | 0.00 | 0.00 | 25340.43 | 368806.52 |
2023-06 | 649773.99 | 188712.37 | 61604.34 | 0.00 | 0.00 | 36027.57 | 363429.71 |
2023-08 | 484480.63 | 143703.28 | 26104.41 | 0.00 | 0.00 | 60035.97 | 254636.97 |
2023-12 | 545562.53 | 212471.88 | 24256.23 | 0.00 | 0.00 | 70236.66 | 238597.76 |
2024-02 | 487115.68 | 206906.48 | 16566.02 | 0.00 | 0.00 | 61471.85 | 202171.33 |
2024-06 | 632519.84 | 222317.55 | 14027.74 | 0.00 | 0.00 | 75614.31 | 320560.24 |
2024-09 | 1025311.56 | 326534.96 | 57007.10 | 0.00 | 0.00 | 121952.32 | 519817.18 |
2024-10 | 1078503.62 | 346385.67 | 61552.87 | 0.00 | 0.00 | 141361.38 | 529203.70 |
2025-06 | 1533697.83 | 372452.37 | 98444.55 | 0.00 | 0.00 | 211081.43 | 851719.48 |
2024-11 | 1397327.73 | 358906.82 | 87008.06 | 0.00 | 0.00 | 212073.51 | 739339.34 |
2025-01 | 1460286.04 | 443208.85 | 99972.84 | 0.00 | 0.00 | 179080.75 | 738023.60 |
2022-08 | 523943.81 | 190551.17 | 32496.97 | 40759.17 | 18208.89 | 67769.83 | 174157.78 |
2023-07 | 499582.90 | 123140.11 | 40877.20 | 0.00 | 0.00 | 48910.48 | 286655.11 |
2023-10 | 395790.74 | 167718.37 | 17569.59 | 0.00 | 0.00 | 44799.01 | 165703.77 |
2023-11 | 400297.26 | 120391.36 | 11014.47 | 0.00 | 0.00 | 66310.67 | 202580.76 |
2024-05 | 543802.46 | 202782.92 | 20436.63 | 0.00 | 0.00 | 62896.49 | 257686.42 |
2025-02 | 1330243.27 | 372594.32 | 86429.16 | 0.00 | 0.00 | 176843.57 | 694376.22 |
2025-03 | 1535494.48 | 406270.30 | 82274.60 | 0.00 | 0.00 | 185339.31 | 861610.27 |
2025-05 | 1873344.49 | 440788.12 | 153140.21 | 0.00 | 0.00 | 206146.33 | 1073269.83 |
2025-07 | 40128.62 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 40128.62 |
_SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-07-25 01:11:51.932 UTC