[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
---|---|---|---|---|---|---|---|
2022-07 | 490055.13 | 215381.76 | 29617.80 | 40759.17 | 18907.99 | 50934.14 | 134454.27 |
2022-08 | 483711.47 | 170211.97 | 24844.61 | 25746.99 | 36075.24 | 59132.32 | 167700.34 |
2023-05 | 688147.61 | 206259.41 | 65222.22 | 0.00 | 0.00 | 42900.22 | 373765.76 |
2022-09 | 520371.79 | 221749.94 | 11929.73 | 33221.07 | 15012.18 | 62571.33 | 175887.54 |
2022-10 | 554143.41 | 214083.56 | 29846.08 | 50349.30 | 33221.07 | 26966.91 | 199676.49 |
2023-07 | 544498.50 | 143508.04 | 37797.58 | 0.00 | 0.00 | 61457.61 | 301735.27 |
2022-11 | 727461.62 | 273689.74 | 36278.52 | 48704.07 | 41254.99 | 50909.14 | 276625.16 |
2022-12 | 594496.02 | 223312.40 | 46835.05 | 6978.26 | 0.00 | 71298.10 | 246072.21 |
2023-08 | 375397.51 | 128704.12 | 15126.05 | 0.00 | 0.00 | 51904.90 | 179662.44 |
2023-09 | 398424.44 | 184960.26 | 18485.04 | 0.00 | 0.00 | 53326.99 | 141652.15 |
2023-01 | 618111.25 | 179262.53 | 60944.85 | 0.00 | 0.00 | 50755.86 | 327148.01 |
2024-01 | 525835.72 | 222275.90 | 21473.41 | 0.00 | 0.00 | 67301.72 | 214784.69 |
2024-02 | 454733.18 | 187344.20 | 28248.58 | 0.00 | 0.00 | 55700.36 | 183440.04 |
2023-02 | 597503.47 | 217954.37 | 24844.61 | 0.00 | 0.00 | 36100.24 | 318604.25 |
2025-01 | 1568507.43 | 447273.13 | 91202.98 | 0.00 | 0.00 | 203475.33 | 826555.99 |
2024-07 | 854899.95 | 189942.60 | 60393.06 | 0.00 | 0.00 | 128253.84 | 476310.45 |
2023-03 | 651762.60 | 224451.07 | 64205.58 | 0.00 | 0.00 | 28626.16 | 334479.79 |
2024-08 | 1035592.29 | 331006.14 | 63453.15 | 0.00 | 0.00 | 132148.71 | 508984.29 |
2023-10 | 350007.87 | 109781.93 | 9231.04 | 0.00 | 0.00 | 48077.28 | 182917.62 |
2024-05 | 581255.58 | 208911.18 | 6469.49 | 0.00 | 0.00 | 59375.28 | 306499.63 |
2024-12 | 1362361.70 | 384383.14 | 114407.60 | 0.00 | 0.00 | 167430.46 | 696140.50 |
2025-03 | 1657493.46 | 448532.80 | 111243.61 | 0.00 | 0.00 | 181830.28 | 915886.77 |
2025-05 | 2020808.64 | 499342.64 | 139405.32 | 0.00 | 0.00 | 256846.75 | 1125213.93 |
2025-06 | 95094.74 | 11504.79 | 8481.83 | 0.00 | 0.00 | 11497.20 | 63610.92 |
2025-04 | 1814128.57 | 419141.39 | 125774.07 | 0.00 | 0.00 | 217554.40 | 1051658.71 |
2025-07 | 4121.22 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4121.22 |
2022-06 | 443973.67 | 202699.65 | 14313.08 | 32026.15 | 36100.24 | 37498.44 | 121336.11 |
2023-04 | 684112.78 | 212666.85 | 53292.49 | 0.00 | 0.00 | 32814.51 | 385338.93 |
2023-06 | 481571.53 | 126519.80 | 39959.37 | 0.00 | 0.00 | 39766.92 | 275325.44 |
2023-11 | 565818.82 | 192719.10 | 23858.10 | 0.00 | 0.00 | 71701.78 | 277539.84 |
2023-12 | 439304.11 | 191797.80 | 12166.90 | 0.00 | 0.00 | 68178.51 | 167160.90 |
2024-03 | 527204.64 | 212159.56 | 11943.94 | 0.00 | 0.00 | 51353.49 | 251747.65 |
2024-04 | 536316.49 | 197881.81 | 29377.19 | 0.00 | 0.00 | 68450.12 | 240607.37 |
2024-06 | 853848.24 | 245821.43 | 39939.91 | 0.00 | 0.00 | 124612.82 | 443474.08 |
2024-09 | 1044408.08 | 333964.51 | 44944.93 | 0.00 | 0.00 | 149978.72 | 515519.92 |
2024-10 | 1233022.61 | 345046.27 | 96297.97 | 0.00 | 0.00 | 172869.60 | 618808.77 |
2024-11 | 1673264.62 | 370529.61 | 117323.96 | 0.00 | 0.00 | 217594.29 | 967816.76 |
2025-02 | 1306907.13 | 357212.82 | 77337.80 | 0.00 | 0.00 | 177154.99 | 695201.52 |
_SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-07-02 07:20:26.131 UTC