[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-01 | 500808.45 | 197325.91 | 28219.60 | 32903.53 | 25365.43 | 68265.65 | 148728.33 |
| 2023-03 | 535890.77 | 221939.20 | 16410.38 | 52129.06 | 25543.71 | 31244.28 | 188624.14 |
| 2023-07 | 620555.82 | 221717.17 | 46314.23 | 0.00 | 0.00 | 25187.15 | 327337.27 |
| 2023-08 | 654852.82 | 227012.70 | 56845.76 | 0.00 | 0.00 | 35782.70 | 335211.66 |
| 2023-09 | 710113.05 | 226191.81 | 64027.30 | 0.00 | 0.00 | 35693.68 | 384200.26 |
| 2024-02 | 359222.72 | 157633.20 | 15890.90 | 0.00 | 0.00 | 50688.06 | 135010.56 |
| 2024-04 | 506224.64 | 167535.18 | 15086.77 | 0.00 | 0.00 | 66759.70 | 256842.99 |
| 2024-05 | 483761.68 | 191515.04 | 25070.63 | 0.00 | 0.00 | 72657.99 | 194518.02 |
| 2024-08 | 498942.36 | 205604.67 | 20594.99 | 0.00 | 0.00 | 53541.31 | 219201.39 |
| 2024-10 | 606689.50 | 224342.54 | 16098.66 | 0.00 | 0.00 | 62379.73 | 303868.57 |
| 2024-11 | 733984.98 | 230164.26 | 32536.80 | 0.00 | 0.00 | 95272.78 | 376011.14 |
| 2025-01 | 1015541.03 | 282342.44 | 65817.47 | 0.00 | 0.00 | 130205.96 | 537175.16 |
| 2025-02 | 962248.54 | 324661.26 | 53863.17 | 0.00 | 0.00 | 125290.91 | 458433.20 |
| 2025-03 | 1108662.86 | 332155.50 | 72390.40 | 0.00 | 0.00 | 138591.60 | 565525.36 |
| 2025-10 | 1957664.59 | 492933.86 | 136804.39 | 0.00 | 0.00 | 243779.20 | 1084147.14 |
| 2025-05 | 1440089.45 | 382892.16 | 130700.69 | 0.00 | 0.00 | 168333.63 | 758162.97 |
| 2023-02 | 501781.34 | 201539.26 | 10531.53 | 28943.70 | 26242.81 | 65971.32 | 168552.72 |
| 2023-06 | 592717.78 | 184104.47 | 46656.77 | 0.00 | 0.00 | 68622.21 | 293334.33 |
| 2023-11 | 580397.98 | 145087.23 | 54289.91 | 0.00 | 0.00 | 36066.03 | 344954.81 |
| 2024-03 | 361416.02 | 128004.90 | 13294.29 | 0.00 | 0.00 | 46597.04 | 173519.79 |
| 2024-06 | 492629.51 | 216779.58 | 20424.75 | 0.00 | 0.00 | 63934.17 | 191491.01 |
| 2024-09 | 501954.77 | 184831.24 | 18481.91 | 0.00 | 0.00 | 63124.64 | 235516.98 |
| 2024-12 | 872050.97 | 204213.26 | 54085.87 | 0.00 | 0.00 | 145029.35 | 468722.49 |
| 2025-07 | 1510896.24 | 403854.69 | 83878.39 | 0.00 | 0.00 | 197468.13 | 825695.03 |
| 2025-08 | 1524460.69 | 397658.86 | 92256.21 | 0.00 | 0.00 | 192560.64 | 841984.98 |
| 2022-11 | 271188.85 | 120998.30 | 7156.54 | 25047.89 | 14134.80 | 22689.54 | 81161.78 |
| 2022-12 | 511193.19 | 228510.90 | 26242.81 | 32725.25 | 33196.07 | 37498.44 | 153019.72 |
| 2023-04 | 625037.99 | 235224.66 | 36799.34 | 43549.32 | 41076.71 | 43752.60 | 224635.36 |
| 2023-05 | 670830.12 | 233012.06 | 54169.87 | 22486.26 | 15012.18 | 68622.21 | 277527.54 |
| 2023-12 | 516214.74 | 142353.70 | 42290.03 | 0.00 | 0.00 | 57297.38 | 274273.63 |
| 2024-07 | 506633.30 | 200775.41 | 20863.64 | 0.00 | 0.00 | 65112.08 | 219882.17 |
| 2025-11 | 689404.65 | 155029.99 | 42817.64 | 0.00 | 0.00 | 90144.61 | 401412.41 |
| 2025-09 | 1800227.12 | 449040.84 | 134744.51 | 0.00 | 0.00 | 204732.37 | 1011709.40 |
| 2025-12 | 18809.53 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 18809.53 |
| 2023-10 | 628397.68 | 209595.14 | 47534.15 | 0.00 | 0.00 | 33221.07 | 338047.32 |
| 2024-01 | 442250.47 | 139083.13 | 10967.45 | 0.00 | 0.00 | 58394.80 | 233805.09 |
| 2025-04 | 1563229.46 | 363671.75 | 94405.89 | 0.00 | 0.00 | 238333.05 | 866818.77 |
| 2025-06 | 1481702.23 | 422651.95 | 97953.86 | 0.00 | 0.00 | 185503.71 | 775592.71 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-12-11 11:16:02.014 UTC