[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-07 | 455670.15 | 169334.59 | 10734.81 | 18590.45 | 36977.62 | 55732.33 | 164300.35 |
| 2023-08 | 533882.73 | 217433.55 | 12628.83 | 47152.59 | 7156.54 | 51836.52 | 197674.70 |
| 2023-09 | 573650.26 | 225531.49 | 32725.25 | 39996.05 | 47534.15 | 31244.28 | 196619.04 |
| 2024-01 | 623943.31 | 224590.09 | 39157.69 | 0.00 | 0.00 | 31822.87 | 328372.66 |
| 2024-02 | 672653.63 | 224476.07 | 64205.58 | 0.00 | 0.00 | 31797.87 | 352174.11 |
| 2024-04 | 659088.11 | 190152.19 | 66376.04 | 0.00 | 0.00 | 31535.12 | 371024.76 |
| 2024-07 | 368056.91 | 127283.12 | 13575.83 | 0.00 | 0.00 | 56161.76 | 171036.20 |
| 2024-10 | 566908.69 | 215568.89 | 26305.33 | 0.00 | 0.00 | 76364.77 | 248669.70 |
| 2026-05 | 44393.39 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 44393.39 |
| 2023-11 | 586774.91 | 223312.40 | 53292.49 | 0.00 | 0.00 | 64701.40 | 245468.62 |
| 2024-08 | 396379.35 | 173754.78 | 17569.59 | 0.00 | 0.00 | 43798.57 | 161256.41 |
| 2025-02 | 492830.66 | 190620.63 | 17591.61 | 0.00 | 0.00 | 46138.15 | 238480.27 |
| 2025-03 | 542292.59 | 198595.74 | 20414.31 | 0.00 | 0.00 | 69122.97 | 254159.57 |
| 2025-04 | 628967.52 | 223430.67 | 13936.21 | 0.00 | 0.00 | 71944.91 | 319655.73 |
| 2025-05 | 838865.62 | 225685.88 | 43465.15 | 0.00 | 0.00 | 121636.26 | 448078.33 |
| 2025-09 | 1306610.33 | 341777.67 | 92972.68 | 0.00 | 0.00 | 195945.91 | 675914.07 |
| 2023-05 | 480202.19 | 217508.55 | 21965.44 | 39182.69 | 43930.88 | 36799.34 | 120815.29 |
| 2025-10 | 1640165.74 | 377017.38 | 126444.72 | 0.00 | 0.00 | 214703.66 | 921999.98 |
| 2024-03 | 657666.69 | 209266.86 | 47355.87 | 0.00 | 0.00 | 39996.05 | 361047.91 |
| 2025-11 | 1359902.91 | 399705.99 | 101306.73 | 0.00 | 0.00 | 163712.52 | 695177.67 |
| 2025-01 | 493267.52 | 205932.67 | 24782.47 | 0.00 | 0.00 | 62547.48 | 200004.90 |
| 2023-04 | 50577.58 | 20909.78 | 3578.27 | 3578.27 | 3399.99 | 699.10 | 18412.17 |
| 2025-06 | 868188.64 | 206411.00 | 57681.43 | 0.00 | 0.00 | 129899.40 | 474196.81 |
| 2023-06 | 510329.83 | 219519.87 | 32496.97 | 37180.90 | 14630.62 | 65068.94 | 141432.53 |
| 2025-07 | 1048587.39 | 340064.68 | 64728.95 | 0.00 | 0.00 | 134240.47 | 509553.29 |
| 2023-10 | 734058.32 | 260075.76 | 36977.62 | 52104.06 | 26941.91 | 63963.28 | 293995.69 |
| 2025-08 | 1087929.23 | 342334.17 | 52707.05 | 0.00 | 0.00 | 141400.22 | 551487.79 |
| 2023-12 | 617957.97 | 186761.61 | 53788.31 | 0.00 | 0.00 | 47876.69 | 329531.36 |
| 2026-03 | 1831751.91 | 424160.09 | 141719.33 | 0.00 | 0.00 | 202968.75 | 1062903.74 |
| 2024-05 | 492709.47 | 124816.98 | 36362.43 | 0.00 | 0.00 | 48888.16 | 282641.90 |
| 2026-04 | 1767666.41 | 433064.62 | 119166.14 | 0.00 | 0.00 | 237755.53 | 977680.12 |
| 2024-06 | 510952.81 | 153471.47 | 32800.74 | 0.00 | 0.00 | 60187.62 | 264492.98 |
| 2024-09 | 383048.55 | 118733.38 | 8965.37 | 0.00 | 0.00 | 56668.23 | 198681.57 |
| 2024-11 | 440986.34 | 182801.13 | 14128.18 | 0.00 | 0.00 | 60811.71 | 183245.32 |
| 2024-12 | 518032.99 | 212664.29 | 22845.78 | 0.00 | 0.00 | 64398.32 | 218124.60 |
| 2025-12 | 1519115.87 | 427608.84 | 93706.12 | 0.00 | 0.00 | 199456.38 | 798344.53 |
| 2026-01 | 1540332.54 | 411956.50 | 88116.20 | 0.00 | 0.00 | 186041.22 | 854218.62 |
| 2026-02 | 1514278.83 | 405654.84 | 99941.98 | 0.00 | 0.00 | 190482.96 | 818199.05 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-05-27 13:14:09.977 UTC