[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2022-10 | 521050.62 | 256602.22 | 25543.71 | 32026.15 | 40352.61 | 31219.28 | 135306.65 |
| 2022-09 | 162684.85 | 67566.55 | 3578.27 | 14313.08 | 6978.26 | 21990.44 | 48258.25 |
| 2023-01 | 519658.67 | 206902.02 | 12628.83 | 55707.33 | 22168.72 | 26966.91 | 195284.86 |
| 2023-08 | 653642.60 | 214921.92 | 50730.86 | 0.00 | 0.00 | 36621.06 | 351368.76 |
| 2023-05 | 611494.28 | 191153.24 | 46110.95 | 0.00 | 0.00 | 22307.98 | 351922.11 |
| 2023-10 | 497938.19 | 138973.74 | 44497.79 | 0.00 | 0.00 | 40272.06 | 274194.60 |
| 2024-02 | 426096.85 | 126257.64 | 14086.33 | 0.00 | 0.00 | 63968.07 | 221784.81 |
| 2023-11 | 468235.90 | 131189.62 | 21217.71 | 0.00 | 0.00 | 67552.06 | 248276.51 |
| 2024-06 | 493702.42 | 193183.42 | 25543.14 | 0.00 | 0.00 | 62441.22 | 212534.64 |
| 2023-12 | 381070.61 | 159879.51 | 17045.82 | 0.00 | 0.00 | 51651.73 | 152493.55 |
| 2024-09 | 693612.31 | 232829.00 | 21650.03 | 0.00 | 0.00 | 81571.39 | 357561.89 |
| 2024-07 | 531541.89 | 204033.81 | 20531.01 | 0.00 | 0.00 | 58761.52 | 248215.55 |
| 2025-06 | 1438407.24 | 386138.58 | 87821.56 | 0.00 | 0.00 | 167442.77 | 797004.33 |
| 2024-11 | 925545.46 | 232081.47 | 60992.30 | 0.00 | 0.00 | 129518.83 | 502952.86 |
| 2025-10 | 30895.93 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 30895.93 |
| 2025-07 | 1768990.90 | 449626.56 | 123810.75 | 0.00 | 0.00 | 218088.20 | 977465.39 |
| 2023-04 | 602828.73 | 222841.58 | 46860.05 | 0.00 | 0.00 | 85789.46 | 247337.64 |
| 2023-06 | 614824.00 | 216862.73 | 42532.68 | 0.00 | 0.00 | 39182.69 | 316245.90 |
| 2024-03 | 520476.38 | 208134.96 | 21184.37 | 0.00 | 0.00 | 69479.87 | 221677.18 |
| 2024-04 | 461705.34 | 187995.31 | 22479.36 | 0.00 | 0.00 | 66614.61 | 184616.06 |
| 2024-05 | 522478.53 | 226594.66 | 16698.48 | 0.00 | 0.00 | 57474.40 | 221710.99 |
| 2024-08 | 567938.15 | 213330.56 | 15315.67 | 0.00 | 0.00 | 60378.29 | 278913.63 |
| 2024-10 | 858807.73 | 214182.35 | 45512.41 | 0.00 | 0.00 | 145963.36 | 453149.61 |
| 2025-01 | 1090296.58 | 350603.81 | 65679.79 | 0.00 | 0.00 | 141493.61 | 532519.37 |
| 2025-04 | 1409742.76 | 432123.15 | 93993.42 | 0.00 | 0.00 | 179886.08 | 703740.11 |
| 2025-05 | 1539487.40 | 412971.78 | 87431.23 | 0.00 | 0.00 | 200899.80 | 838184.59 |
| 2022-11 | 479313.83 | 172952.12 | 28918.70 | 37180.90 | 21787.16 | 63289.18 | 155185.77 |
| 2022-12 | 547071.16 | 219138.07 | 10734.81 | 28943.70 | 29821.08 | 77926.05 | 180507.45 |
| 2023-02 | 551584.82 | 228410.66 | 40377.61 | 32318.69 | 37295.16 | 23566.92 | 189615.78 |
| 2023-03 | 683670.00 | 218217.18 | 50591.60 | 37295.16 | 22168.72 | 68240.65 | 287156.69 |
| 2023-07 | 730527.01 | 248003.97 | 60830.59 | 0.00 | 0.00 | 35871.96 | 385820.49 |
| 2023-09 | 613235.02 | 161188.03 | 60075.17 | 0.00 | 0.00 | 39644.30 | 352327.52 |
| 2024-01 | 384758.71 | 152193.14 | 15365.71 | 0.00 | 0.00 | 43601.08 | 173598.78 |
| 2024-12 | 1052063.51 | 331144.55 | 69267.90 | 0.00 | 0.00 | 128206.07 | 523444.99 |
| 2025-02 | 1373062.77 | 341047.20 | 81260.56 | 0.00 | 0.00 | 202230.10 | 748524.91 |
| 2025-03 | 1558014.13 | 360190.81 | 138608.34 | 0.00 | 0.00 | 198039.50 | 861175.48 |
| 2025-08 | 1905887.83 | 478644.23 | 147852.31 | 0.00 | 0.00 | 211987.82 | 1067403.47 |
| 2025-09 | 1166334.78 | 263878.07 | 69157.68 | 0.00 | 0.00 | 168210.40 | 665088.63 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-10-18 15:17:11.235 UTC