[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-02 | 1419370.76 | 391885.38 | 84557.96 | 0.00 | 0.00 | 170960.99 | 771966.43 |
| 2023-02 | 534462.84 | 171749.43 | 46631.77 | 0.00 | 0.00 | 50755.86 | 265325.78 |
| 2023-07 | 540006.35 | 133122.68 | 54069.17 | 0.00 | 0.00 | 42958.47 | 309856.03 |
| 2023-08 | 537648.87 | 155355.99 | 35354.23 | 0.00 | 0.00 | 61675.06 | 285263.59 |
| 2024-07 | 847387.18 | 250368.01 | 38966.46 | 0.00 | 0.00 | 122657.85 | 435394.86 |
| 2024-11 | 1149398.30 | 343743.41 | 85699.20 | 0.00 | 0.00 | 156631.94 | 563323.75 |
| 2025-05 | 1892136.63 | 449905.52 | 141554.52 | 0.00 | 0.00 | 215289.17 | 1085387.42 |
| 2025-06 | 1932188.86 | 490189.75 | 130130.88 | 0.00 | 0.00 | 250648.63 | 1061219.60 |
| 2024-10 | 1058099.87 | 346264.98 | 48430.95 | 0.00 | 0.00 | 141833.63 | 521570.31 |
| 2025-08 | 9219.20 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 9219.20 |
| 2025-01 | 1393197.60 | 373952.84 | 127101.61 | 0.00 | 0.00 | 181020.15 | 711123.00 |
| 2022-07 | 378458.91 | 170380.96 | 14313.08 | 32026.15 | 32725.25 | 33221.07 | 95792.40 |
| 2022-11 | 557093.09 | 226013.29 | 22689.54 | 44070.14 | 33221.07 | 24786.84 | 206312.21 |
| 2022-08 | 521471.44 | 232891.55 | 29617.80 | 25746.99 | 22282.98 | 51633.24 | 159298.88 |
| 2023-03 | 662122.10 | 240618.91 | 39157.69 | 0.00 | 0.00 | 32521.97 | 349823.53 |
| 2022-09 | 470676.08 | 172887.86 | 21266.34 | 36481.80 | 32496.97 | 54854.95 | 152688.16 |
| 2023-06 | 621672.70 | 196833.54 | 51112.42 | 0.00 | 0.00 | 35743.68 | 337983.06 |
| 2022-12 | 723933.35 | 266240.66 | 44134.16 | 44248.42 | 41254.99 | 50909.14 | 277145.98 |
| 2023-10 | 410956.09 | 175933.10 | 22122.44 | 0.00 | 0.00 | 58732.06 | 154168.49 |
| 2023-04 | 610685.89 | 213602.00 | 53470.77 | 0.00 | 0.00 | 25047.89 | 318565.23 |
| 2024-02 | 488860.21 | 209264.56 | 21473.41 | 0.00 | 0.00 | 62556.87 | 195565.37 |
| 2023-05 | 752620.73 | 218946.01 | 64027.30 | 0.00 | 0.00 | 39971.05 | 429676.37 |
| 2024-03 | 458741.12 | 180859.92 | 23995.60 | 0.00 | 0.00 | 64025.34 | 189860.26 |
| 2023-11 | 331746.30 | 110487.99 | 5098.64 | 0.00 | 0.00 | 45466.52 | 170693.15 |
| 2024-04 | 526127.55 | 215435.64 | 16196.92 | 0.00 | 0.00 | 50353.05 | 244141.94 |
| 2023-12 | 552475.78 | 185298.68 | 21799.61 | 0.00 | 0.00 | 69563.51 | 275813.98 |
| 2024-05 | 538018.25 | 196632.81 | 25629.65 | 0.00 | 0.00 | 67572.75 | 248183.04 |
| 2024-08 | 849686.72 | 188829.12 | 58871.93 | 0.00 | 0.00 | 133113.65 | 468872.02 |
| 2024-09 | 1016471.12 | 305321.53 | 63111.13 | 0.00 | 0.00 | 129195.08 | 518843.38 |
| 2025-03 | 1453650.67 | 411790.15 | 86077.42 | 0.00 | 0.00 | 195219.81 | 760563.29 |
| 2025-04 | 1540647.12 | 406612.71 | 92611.90 | 0.00 | 0.00 | 185321.88 | 856100.63 |
| 2025-07 | 357477.55 | 62961.31 | 28581.93 | 0.00 | 0.00 | 40630.31 | 225304.00 |
| 2022-10 | 498584.63 | 204240.15 | 11230.63 | 36799.34 | 15012.18 | 65450.50 | 165851.83 |
| 2023-01 | 622398.08 | 222588.30 | 50413.32 | 18412.17 | 3578.27 | 78454.64 | 248951.38 |
| 2023-09 | 383301.78 | 129575.98 | 13932.00 | 0.00 | 0.00 | 45622.46 | 194171.34 |
| 2024-01 | 468358.36 | 200192.46 | 18357.79 | 0.00 | 0.00 | 70224.78 | 179583.33 |
| 2024-06 | 561078.60 | 208110.33 | 8167.93 | 0.00 | 0.00 | 55883.27 | 288917.07 |
| 2024-12 | 1688247.21 | 392900.71 | 106559.40 | 0.00 | 0.00 | 227841.66 | 960945.44 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-08-05 10:00:29.337 UTC