[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-10 | 546219.02 | 232064.17 | 9253.84 | 52129.06 | 25543.71 | 31244.28 | 195983.96 |
| 2024-02 | 550663.69 | 194324.95 | 42735.96 | 0.00 | 0.00 | 14630.62 | 298972.16 |
| 2024-09 | 366291.45 | 157043.54 | 13819.48 | 0.00 | 0.00 | 51869.18 | 143559.25 |
| 2025-06 | 713155.02 | 232508.63 | 28512.76 | 0.00 | 0.00 | 88624.90 | 363508.73 |
| 2025-07 | 837518.35 | 201966.04 | 42891.03 | 0.00 | 0.00 | 146858.76 | 445802.52 |
| 2026-06 | 1007448.28 | 235532.54 | 61486.93 | 0.00 | 0.00 | 138475.54 | 571953.27 |
| 2025-12 | 1525829.32 | 386470.35 | 136305.43 | 0.00 | 0.00 | 192838.58 | 810214.96 |
| 2026-01 | 1458250.65 | 424665.36 | 92027.31 | 0.00 | 0.00 | 185162.70 | 756395.28 |
| 2023-06 | 198963.37 | 74519.81 | 3578.27 | 17891.35 | 14134.80 | 22689.54 | 66149.60 |
| 2023-07 | 520198.24 | 256805.50 | 25543.71 | 35604.42 | 33196.07 | 33920.17 | 135128.37 |
| 2023-08 | 484443.58 | 190640.19 | 28918.70 | 33602.63 | 21787.16 | 61287.39 | 148207.51 |
| 2023-09 | 524203.34 | 197871.73 | 14109.80 | 28943.70 | 29821.08 | 76527.85 | 176929.18 |
| 2023-12 | 659752.77 | 222137.99 | 50591.60 | 29439.52 | 18590.45 | 61465.67 | 277527.54 |
| 2024-03 | 648292.10 | 226363.60 | 49689.22 | 0.00 | 0.00 | 46339.23 | 325900.05 |
| 2024-10 | 379577.65 | 138428.55 | 15365.71 | 0.00 | 0.00 | 42583.83 | 183199.56 |
| 2025-05 | 575314.15 | 212834.51 | 15315.67 | 0.00 | 0.00 | 58979.72 | 288184.25 |
| 2026-05 | 1944301.41 | 475724.18 | 142257.78 | 0.00 | 0.00 | 230397.36 | 1095922.09 |
| 2026-07 | 27606.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 27606.44 |
| 2023-11 | 617207.35 | 228093.12 | 43955.88 | 40174.33 | 37498.44 | 40174.33 | 227311.25 |
| 2024-06 | 617913.71 | 161820.28 | 61121.81 | 0.00 | 0.00 | 39644.30 | 355327.32 |
| 2024-08 | 469862.73 | 146609.06 | 22000.70 | 0.00 | 0.00 | 67985.14 | 233267.83 |
| 2024-12 | 516797.60 | 205604.54 | 22627.28 | 0.00 | 0.00 | 71263.30 | 217302.48 |
| 2025-01 | 476834.26 | 202010.97 | 22868.10 | 0.00 | 0.00 | 62863.19 | 189092.00 |
| 2025-02 | 463261.89 | 194530.94 | 15937.81 | 0.00 | 0.00 | 57655.08 | 195138.06 |
| 2025-09 | 1026054.62 | 321535.60 | 70003.52 | 0.00 | 0.00 | 130355.86 | 504159.64 |
| 2025-10 | 1106130.55 | 351396.45 | 65793.62 | 0.00 | 0.00 | 136211.96 | 552728.52 |
| 2026-03 | 1485938.20 | 381350.04 | 96057.80 | 0.00 | 0.00 | 178762.54 | 829767.82 |
| 2025-11 | 1506963.37 | 365734.88 | 93582.26 | 0.00 | 0.00 | 222154.20 | 825492.03 |
| 2024-01 | 636470.38 | 212666.61 | 50235.04 | 0.00 | 0.00 | 79357.02 | 294211.71 |
| 2024-04 | 711842.81 | 237804.00 | 64205.58 | 0.00 | 0.00 | 28715.42 | 381117.81 |
| 2024-05 | 616918.26 | 200837.12 | 40199.33 | 0.00 | 0.00 | 36621.06 | 339260.75 |
| 2024-07 | 506758.77 | 132148.08 | 42316.23 | 0.00 | 0.00 | 45525.48 | 286768.98 |
| 2024-11 | 467041.57 | 150460.59 | 15086.77 | 0.00 | 0.00 | 67542.69 | 233951.52 |
| 2025-03 | 512880.66 | 200070.53 | 23471.72 | 0.00 | 0.00 | 60281.98 | 229056.43 |
| 2025-04 | 515220.29 | 205119.24 | 20531.01 | 0.00 | 0.00 | 56428.31 | 233141.73 |
| 2025-08 | 982098.12 | 257881.57 | 60307.79 | 0.00 | 0.00 | 129991.37 | 533917.39 |
| 2026-02 | 1386873.22 | 374634.52 | 79627.74 | 0.00 | 0.00 | 181808.43 | 750802.53 |
| 2026-04 | 1767580.70 | 461778.44 | 124184.31 | 0.00 | 0.00 | 211112.74 | 970505.21 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-07-17 00:52:58.920 UTC