[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-01 | 1042444.23 | 349957.72 | 57792.78 | 0.00 | 0.00 | 137983.23 | 496710.50 |
| 2025-06 | 1457728.80 | 390559.96 | 79912.82 | 0.00 | 0.00 | 190240.74 | 797015.28 |
| 2025-04 | 1405127.11 | 373320.94 | 125855.63 | 0.00 | 0.00 | 165039.95 | 740910.59 |
| 2022-11 | 489926.85 | 221557.64 | 26242.81 | 29146.98 | 33196.07 | 33920.17 | 145863.18 |
| 2022-10 | 271188.85 | 120998.30 | 7156.54 | 25047.89 | 14134.80 | 22689.54 | 81161.78 |
| 2022-12 | 514918.25 | 204279.17 | 28219.60 | 36481.80 | 25365.43 | 68265.65 | 152306.60 |
| 2023-05 | 608429.06 | 189080.94 | 46656.77 | 0.00 | 0.00 | 79357.02 | 293334.33 |
| 2023-07 | 653504.62 | 222785.33 | 60424.03 | 0.00 | 0.00 | 35782.70 | 334512.56 |
| 2024-03 | 513527.16 | 167535.18 | 15086.77 | 0.00 | 0.00 | 68941.26 | 261963.95 |
| 2023-12 | 454271.23 | 142142.06 | 10967.45 | 0.00 | 0.00 | 64803.14 | 236358.58 |
| 2024-04 | 474343.40 | 186589.21 | 25070.63 | 0.00 | 0.00 | 70214.64 | 192468.92 |
| 2024-01 | 383433.86 | 162248.72 | 19072.90 | 0.00 | 0.00 | 55436.04 | 146676.20 |
| 2024-12 | 1014166.27 | 272126.41 | 62757.96 | 0.00 | 0.00 | 130016.85 | 549265.05 |
| 2024-05 | 502047.79 | 221705.41 | 20424.75 | 0.00 | 0.00 | 66377.52 | 193540.11 |
| 2024-06 | 498153.54 | 196260.64 | 20080.65 | 0.00 | 0.00 | 65112.08 | 216700.17 |
| 2024-07 | 501891.15 | 210119.44 | 21377.98 | 0.00 | 0.00 | 51359.75 | 219033.98 |
| 2025-02 | 1008539.34 | 295539.75 | 68402.80 | 0.00 | 0.00 | 119391.10 | 525205.69 |
| 2023-02 | 488852.44 | 204226.13 | 9253.84 | 44273.42 | 25543.71 | 27666.01 | 177889.33 |
| 2023-09 | 606610.52 | 201917.78 | 47534.15 | 0.00 | 0.00 | 33221.07 | 323937.52 |
| 2023-10 | 602185.14 | 152764.59 | 54289.91 | 0.00 | 0.00 | 36066.03 | 359064.61 |
| 2024-02 | 339771.30 | 125955.80 | 10112.29 | 0.00 | 0.00 | 41849.06 | 161854.15 |
| 2024-11 | 849842.64 | 203986.43 | 53842.48 | 0.00 | 0.00 | 144489.36 | 447524.37 |
| 2025-03 | 1606740.38 | 385433.90 | 97766.78 | 0.00 | 0.00 | 245570.33 | 877969.37 |
| 2025-08 | 1850980.54 | 472768.35 | 142124.93 | 0.00 | 0.00 | 208503.38 | 1027583.88 |
| 2025-11 | 18809.53 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 18809.53 |
| 2025-09 | 1890389.12 | 468613.43 | 134057.13 | 0.00 | 0.00 | 237260.43 | 1050458.13 |
| 2025-10 | 756680.12 | 179350.42 | 45564.90 | 0.00 | 0.00 | 96663.38 | 435101.42 |
| 2023-01 | 545419.68 | 215852.34 | 10531.53 | 36799.34 | 26242.81 | 73127.86 | 182865.80 |
| 2023-03 | 635594.52 | 238624.65 | 43955.88 | 43549.32 | 41076.71 | 43752.60 | 224635.36 |
| 2023-04 | 655118.84 | 228035.59 | 54169.87 | 22486.26 | 15012.18 | 57887.40 | 277527.54 |
| 2023-06 | 588707.95 | 200604.11 | 42735.96 | 0.00 | 0.00 | 25187.15 | 320180.73 |
| 2023-08 | 743309.12 | 251532.24 | 64027.30 | 0.00 | 0.00 | 35693.68 | 392055.90 |
| 2023-11 | 494325.04 | 136728.35 | 42290.03 | 0.00 | 0.00 | 48707.48 | 266599.18 |
| 2024-08 | 507485.74 | 184831.24 | 18481.91 | 0.00 | 0.00 | 65306.20 | 238866.39 |
| 2024-09 | 582172.23 | 213399.79 | 16098.66 | 0.00 | 0.00 | 56710.04 | 295963.74 |
| 2024-10 | 758502.25 | 241107.01 | 32536.80 | 0.00 | 0.00 | 100942.47 | 383915.97 |
| 2025-05 | 1516664.57 | 432223.17 | 102798.92 | 0.00 | 0.00 | 188797.39 | 792845.09 |
| 2025-07 | 1526874.71 | 387226.08 | 88841.36 | 0.00 | 0.00 | 196017.02 | 854790.25 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-11-11 10:53:29.718 UTC