[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-02 | 444572.53 | 169106.31 | 17688.07 | 32903.53 | 25365.43 | 61312.39 | 138196.80 |
| 2023-06 | 614131.15 | 220065.69 | 47013.33 | 19111.27 | 7855.64 | 78657.92 | 241427.30 |
| 2023-10 | 748521.64 | 230151.64 | 64027.30 | 0.00 | 0.00 | 39271.95 | 415070.75 |
| 2023-11 | 608058.72 | 202438.60 | 47534.15 | 0.00 | 0.00 | 29642.80 | 328443.17 |
| 2024-12 | 812544.66 | 250651.78 | 38210.13 | 0.00 | 0.00 | 119979.28 | 403703.47 |
| 2025-02 | 936795.30 | 265440.23 | 58391.81 | 0.00 | 0.00 | 121716.64 | 491246.62 |
| 2023-01 | 499862.56 | 221304.36 | 36774.34 | 29325.26 | 21762.16 | 41076.71 | 149619.73 |
| 2023-04 | 522098.51 | 221760.92 | 16410.38 | 44273.42 | 29821.08 | 28365.11 | 181467.60 |
| 2023-08 | 632682.58 | 230468.94 | 42532.68 | 0.00 | 0.00 | 28765.42 | 330915.54 |
| 2023-09 | 630732.31 | 223637.71 | 57049.04 | 0.00 | 0.00 | 32204.43 | 317841.13 |
| 2023-12 | 586086.28 | 139762.18 | 55204.09 | 0.00 | 0.00 | 46576.45 | 344543.56 |
| 2024-03 | 394600.62 | 169318.03 | 20073.34 | 0.00 | 0.00 | 57617.60 | 147591.65 |
| 2024-07 | 522031.10 | 225501.94 | 20424.75 | 0.00 | 0.00 | 65500.15 | 210604.26 |
| 2024-09 | 489249.47 | 200457.81 | 17762.90 | 0.00 | 0.00 | 50097.52 | 220931.24 |
| 2025-06 | 1370887.63 | 369272.95 | 116985.83 | 0.00 | 0.00 | 168907.37 | 715721.48 |
| 2025-08 | 1475906.99 | 406575.06 | 91118.25 | 0.00 | 0.00 | 202832.13 | 775381.55 |
| 2025-07 | 1552117.95 | 437001.17 | 99217.98 | 0.00 | 0.00 | 184847.59 | 831051.21 |
| 2022-12 | 338755.40 | 156424.44 | 7156.54 | 28447.88 | 25568.71 | 26064.53 | 95093.30 |
| 2023-07 | 593416.88 | 181924.40 | 50235.04 | 0.00 | 0.00 | 54309.13 | 306948.31 |
| 2024-02 | 402798.62 | 119911.97 | 13149.01 | 0.00 | 0.00 | 49804.90 | 219932.74 |
| 2024-04 | 341745.21 | 123799.39 | 7930.73 | 0.00 | 0.00 | 43765.70 | 166249.39 |
| 2024-05 | 529377.30 | 175378.09 | 18967.52 | 0.00 | 0.00 | 70879.47 | 264152.22 |
| 2024-08 | 478044.91 | 185922.26 | 23695.73 | 0.00 | 0.00 | 67122.35 | 201304.57 |
| 2024-11 | 563419.57 | 204193.56 | 12000.46 | 0.00 | 0.00 | 53183.64 | 294041.91 |
| 2025-10 | 1888893.41 | 457361.87 | 138004.59 | 0.00 | 0.00 | 221010.44 | 1072516.51 |
| 2025-11 | 1918212.66 | 480220.32 | 134883.95 | 0.00 | 0.00 | 239893.95 | 1063214.44 |
| 2023-03 | 548997.95 | 215852.34 | 10531.53 | 36799.34 | 26242.81 | 73127.86 | 186444.07 |
| 2023-05 | 688372.68 | 248349.31 | 47534.15 | 46924.31 | 43955.88 | 43752.60 | 257856.43 |
| 2024-01 | 514047.91 | 152536.83 | 37797.58 | 0.00 | 0.00 | 55376.86 | 268336.64 |
| 2024-06 | 461490.27 | 192218.44 | 20189.44 | 0.00 | 0.00 | 66489.12 | 182593.27 |
| 2024-10 | 551523.95 | 206158.51 | 22580.11 | 0.00 | 0.00 | 70139.17 | 252646.16 |
| 2025-01 | 847324.45 | 194701.68 | 55838.20 | 0.00 | 0.00 | 128812.17 | 467972.40 |
| 2025-03 | 1062187.12 | 354062.46 | 54917.57 | 0.00 | 0.00 | 142181.27 | 511025.82 |
| 2025-04 | 1073715.98 | 319634.18 | 78927.98 | 0.00 | 0.00 | 130897.81 | 544256.01 |
| 2025-05 | 1664757.88 | 384932.70 | 104402.60 | 0.00 | 0.00 | 245817.42 | 929605.16 |
| 2025-09 | 1492390.41 | 394198.99 | 86909.04 | 0.00 | 0.00 | 178628.04 | 832654.34 |
| 2025-12 | 543998.93 | 121291.16 | 34447.36 | 0.00 | 0.00 | 69721.83 | 318538.58 |
| 2026-01 | 14326.40 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 14326.40 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-01-08 15:34:37.000 UTC