[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-07 | 1468925.19 | 404964.12 | 88759.12 | 0.00 | 0.00 | 197875.80 | 777326.15 |
| 2023-05 | 641098.06 | 223643.96 | 54169.87 | 19111.27 | 7855.64 | 79357.02 | 256960.30 |
| 2023-07 | 630006.69 | 231371.32 | 42532.68 | 0.00 | 0.00 | 28765.42 | 327337.27 |
| 2024-03 | 354565.77 | 123799.39 | 11112.73 | 0.00 | 0.00 | 45947.26 | 173706.39 |
| 2024-06 | 501743.44 | 219248.08 | 20424.75 | 0.00 | 0.00 | 64717.16 | 197353.45 |
| 2024-07 | 491535.49 | 192176.12 | 20863.64 | 0.00 | 0.00 | 65723.78 | 212771.95 |
| 2024-08 | 496046.55 | 200457.81 | 20594.99 | 0.00 | 0.00 | 52279.08 | 222714.67 |
| 2024-09 | 525388.60 | 198701.51 | 20531.01 | 0.00 | 0.00 | 67174.62 | 238981.46 |
| 2024-12 | 855181.52 | 199525.14 | 53297.65 | 0.00 | 0.00 | 137381.94 | 464976.79 |
| 2023-06 | 578404.70 | 177647.03 | 50235.04 | 0.00 | 0.00 | 54309.13 | 296213.50 |
| 2025-03 | 1117041.96 | 334181.78 | 79355.67 | 0.00 | 0.00 | 135824.95 | 567679.56 |
| 2023-09 | 723880.31 | 222995.10 | 60449.03 | 0.00 | 0.00 | 39271.95 | 401164.23 |
| 2025-05 | 1405573.92 | 371162.36 | 122047.87 | 0.00 | 0.00 | 170164.26 | 742199.43 |
| 2023-11 | 570556.70 | 139762.18 | 55204.09 | 0.00 | 0.00 | 40296.69 | 335293.74 |
| 2022-12 | 504343.21 | 225085.91 | 33196.07 | 29325.26 | 22461.26 | 41076.71 | 153198.00 |
| 2024-01 | 422186.18 | 130709.63 | 13149.01 | 0.00 | 0.00 | 52248.25 | 226079.29 |
| 2023-02 | 494485.54 | 201539.26 | 6953.26 | 36799.34 | 18590.45 | 61872.23 | 168731.00 |
| 2024-04 | 509542.98 | 173306.67 | 16918.42 | 0.00 | 0.00 | 65733.36 | 253584.53 |
| 2023-10 | 632700.05 | 209595.14 | 51112.42 | 0.00 | 0.00 | 29642.80 | 342349.69 |
| 2025-01 | 1053384.82 | 298729.64 | 64545.01 | 0.00 | 0.00 | 134883.88 | 555226.29 |
| 2023-12 | 518518.04 | 146102.29 | 37797.58 | 0.00 | 0.00 | 59213.27 | 275404.90 |
| 2025-04 | 1630071.59 | 383043.29 | 99340.56 | 0.00 | 0.00 | 244560.53 | 903127.21 |
| 2024-02 | 373451.95 | 164954.91 | 16891.34 | 0.00 | 0.00 | 55436.04 | 136169.66 |
| 2025-09 | 1827383.53 | 440795.46 | 136201.76 | 0.00 | 0.00 | 217046.24 | 1033340.07 |
| 2024-05 | 481324.59 | 194289.86 | 22238.54 | 0.00 | 0.00 | 71635.23 | 193160.96 |
| 2024-10 | 589554.92 | 211650.56 | 14049.56 | 0.00 | 0.00 | 56148.19 | 307706.61 |
| 2025-10 | 1979722.54 | 496786.73 | 136686.78 | 0.00 | 0.00 | 243858.15 | 1102390.88 |
| 2025-12 | 15832.23 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 15832.23 |
| 2025-08 | 1543731.52 | 409338.86 | 90822.00 | 0.00 | 0.00 | 186314.57 | 857256.09 |
| 2025-11 | 542493.10 | 121291.16 | 34447.36 | 0.00 | 0.00 | 69721.83 | 317032.75 |
| 2022-11 | 323743.22 | 145689.63 | 7156.54 | 28447.88 | 24869.61 | 26064.53 | 91515.03 |
| 2023-01 | 498881.66 | 190372.65 | 24844.61 | 32903.53 | 33017.79 | 68989.75 | 148753.33 |
| 2023-03 | 532833.32 | 221760.92 | 16410.38 | 44273.42 | 29821.08 | 31943.38 | 188624.14 |
| 2023-04 | 661405.77 | 244771.04 | 40377.61 | 46924.31 | 43955.88 | 43053.50 | 242323.43 |
| 2023-08 | 648420.38 | 227012.70 | 57049.04 | 0.00 | 0.00 | 32204.43 | 332154.21 |
| 2024-11 | 766293.17 | 239842.54 | 35835.90 | 0.00 | 0.00 | 107822.32 | 382792.41 |
| 2025-02 | 940666.04 | 312211.23 | 53251.46 | 0.00 | 0.00 | 127674.08 | 447529.27 |
| 2025-06 | 1507758.64 | 423472.24 | 97664.15 | 0.00 | 0.00 | 182117.39 | 804504.86 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-12-09 11:44:46.150 UTC