[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
---|---|---|---|---|---|---|---|
2025-04 | 1477526.03 | 399746.94 | 84588.17 | 0.00 | 0.00 | 178199.28 | 814991.64 |
2022-08 | 491978.64 | 242199.88 | 21965.44 | 35604.42 | 43930.88 | 33920.17 | 114357.85 |
2023-01 | 724225.89 | 249340.95 | 51087.42 | 41572.53 | 26941.91 | 63963.28 | 291319.80 |
2022-07 | 79902.84 | 28765.42 | 3578.27 | 7156.54 | 3399.99 | 7855.64 | 29146.98 |
2022-09 | 501075.99 | 190551.17 | 32496.97 | 40759.17 | 14630.62 | 64191.56 | 158446.50 |
2022-11 | 523033.66 | 210302.01 | 12628.83 | 50730.86 | 7855.64 | 47737.43 | 193778.89 |
2023-03 | 617957.97 | 186761.61 | 53788.31 | 0.00 | 0.00 | 47876.69 | 329531.36 |
2023-04 | 609109.41 | 221011.82 | 32001.15 | 0.00 | 0.00 | 31822.87 | 324273.57 |
2022-10 | 456661.79 | 183444.39 | 10734.81 | 15012.18 | 36977.62 | 56431.43 | 154061.36 |
2022-12 | 590614.23 | 225709.77 | 32725.25 | 46949.31 | 46835.05 | 31244.28 | 207150.57 |
2023-05 | 710469.61 | 235706.70 | 71362.12 | 0.00 | 0.00 | 32496.97 | 370903.82 |
2023-09 | 495495.74 | 145774.70 | 28285.97 | 0.00 | 0.00 | 60297.76 | 261137.31 |
2023-07 | 681549.61 | 200052.54 | 66376.04 | 0.00 | 0.00 | 36027.57 | 379093.46 |
2023-02 | 557652.93 | 223312.40 | 39182.69 | 0.00 | 0.00 | 64701.40 | 230456.44 |
2023-06 | 634684.61 | 201614.50 | 47355.87 | 0.00 | 0.00 | 39296.95 | 346417.29 |
2023-10 | 371514.38 | 133297.21 | 13575.83 | 0.00 | 0.00 | 53980.20 | 170661.14 |
2024-06 | 521108.22 | 195060.25 | 19653.64 | 0.00 | 0.00 | 62426.64 | 243967.69 |
2023-08 | 494431.28 | 122613.40 | 40877.20 | 0.00 | 0.00 | 46467.13 | 284473.55 |
2024-02 | 436623.22 | 178438.01 | 14128.18 | 0.00 | 0.00 | 60811.71 | 183245.32 |
2023-11 | 384195.64 | 167740.69 | 17569.59 | 0.00 | 0.00 | 43798.57 | 155086.79 |
2024-09 | 868888.94 | 203459.30 | 57734.87 | 0.00 | 0.00 | 123500.68 | 484194.09 |
2024-01 | 559631.62 | 217882.91 | 24256.23 | 0.00 | 0.00 | 72266.57 | 245225.91 |
2024-07 | 653739.31 | 227702.34 | 14810.73 | 0.00 | 0.00 | 81268.11 | 329958.13 |
2023-12 | 394688.74 | 120782.48 | 11014.47 | 0.00 | 0.00 | 60766.43 | 202125.36 |
2024-11 | 1056291.79 | 339527.11 | 54997.20 | 0.00 | 0.00 | 135991.50 | 525775.98 |
2024-03 | 518032.99 | 212664.29 | 22845.78 | 0.00 | 0.00 | 64398.32 | 218124.60 |
2024-08 | 864844.78 | 237743.07 | 45843.05 | 0.00 | 0.00 | 129175.46 | 452083.20 |
2024-04 | 474436.00 | 189933.24 | 24782.47 | 0.00 | 0.00 | 62547.48 | 197172.81 |
2025-06 | 1771608.53 | 416600.31 | 136594.21 | 0.00 | 0.00 | 194343.05 | 1024070.96 |
2024-05 | 553558.54 | 221361.14 | 20423.70 | 0.00 | 0.00 | 52834.48 | 258939.22 |
2024-12 | 1417583.56 | 369213.70 | 94928.11 | 0.00 | 0.00 | 212602.91 | 740838.84 |
2025-05 | 1703516.38 | 443688.37 | 112031.42 | 0.00 | 0.00 | 215227.59 | 932569.00 |
2024-10 | 1046824.16 | 330573.12 | 61826.72 | 0.00 | 0.00 | 132096.97 | 522327.35 |
2025-03 | 1519115.87 | 427608.84 | 93706.12 | 0.00 | 0.00 | 199456.38 | 798344.53 |
2025-08 | 41447.13 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 41447.13 |
2025-01 | 1579196.48 | 359497.07 | 128377.28 | 0.00 | 0.00 | 206303.34 | 885018.79 |
2025-07 | 1704325.01 | 414800.43 | 115729.85 | 0.00 | 0.00 | 229478.54 | 944316.19 |
2025-02 | 1271136.37 | 377506.14 | 92653.54 | 0.00 | 0.00 | 152544.38 | 648432.31 |
_SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-08-25 22:33:17.454 UTC