[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-09 | 1246569.51 | 347000.15 | 90215.37 | 0.00 | 0.00 | 179362.97 | 629991.02 |
| 2023-06 | 488300.37 | 218960.03 | 25340.43 | 37180.90 | 14630.62 | 54334.13 | 137854.26 |
| 2024-03 | 672678.87 | 219302.57 | 43256.78 | 0.00 | 0.00 | 36621.06 | 373498.46 |
| 2026-04 | 1906545.20 | 471979.24 | 129438.17 | 0.00 | 0.00 | 257229.32 | 1047898.47 |
| 2023-04 | 14477.34 | 3399.99 | 3578.27 | 0.00 | 3399.99 | 0.00 | 4099.09 |
| 2023-05 | 476802.20 | 209831.19 | 21965.44 | 39182.69 | 40352.61 | 37498.44 | 127971.83 |
| 2023-07 | 485198.69 | 177393.51 | 17891.35 | 22168.72 | 36977.62 | 66467.14 | 164300.35 |
| 2023-09 | 540950.01 | 210861.85 | 29846.08 | 39996.05 | 40377.61 | 26966.91 | 192901.51 |
| 2023-12 | 614557.98 | 190022.34 | 57366.58 | 0.00 | 0.00 | 51454.96 | 315714.10 |
| 2024-06 | 518946.66 | 143198.89 | 37687.44 | 0.00 | 0.00 | 61590.07 | 276470.26 |
| 2024-08 | 409081.02 | 182225.49 | 15520.49 | 0.00 | 0.00 | 49450.12 | 161884.92 |
| 2024-09 | 350132.44 | 106293.80 | 9231.04 | 0.00 | 0.00 | 52197.80 | 182409.80 |
| 2024-10 | 574863.67 | 208348.98 | 23858.10 | 0.00 | 0.00 | 72219.10 | 270437.49 |
| 2025-01 | 505552.54 | 199072.92 | 26831.57 | 0.00 | 0.00 | 63352.49 | 216295.56 |
| 2025-02 | 477407.57 | 194303.03 | 14147.82 | 0.00 | 0.00 | 46776.05 | 222180.67 |
| 2025-03 | 566491.40 | 211358.11 | 23858.10 | 0.00 | 0.00 | 70884.08 | 260391.11 |
| 2025-06 | 829594.00 | 185465.99 | 55318.40 | 0.00 | 0.00 | 120423.83 | 468385.78 |
| 2026-03 | 1840539.83 | 420903.95 | 140104.88 | 0.00 | 0.00 | 211892.20 | 1067638.80 |
| 2026-05 | 49005.84 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 49005.84 |
| 2023-10 | 749769.60 | 270607.29 | 36977.62 | 55682.33 | 34098.45 | 54487.41 | 297916.50 |
| 2023-11 | 584816.87 | 219734.13 | 49714.22 | 0.00 | 0.00 | 71298.10 | 244070.42 |
| 2024-02 | 666953.06 | 210341.27 | 64205.58 | 0.00 | 0.00 | 31797.87 | 360608.34 |
| 2024-04 | 641031.55 | 192962.69 | 64523.12 | 0.00 | 0.00 | 33126.68 | 350419.06 |
| 2024-05 | 511811.42 | 129180.10 | 44584.28 | 0.00 | 0.00 | 44259.37 | 293787.67 |
| 2025-04 | 556102.36 | 196402.02 | 9754.45 | 0.00 | 0.00 | 57099.72 | 292846.17 |
| 2025-05 | 877685.78 | 250281.58 | 42389.65 | 0.00 | 0.00 | 129565.03 | 455449.52 |
| 2025-11 | 1329632.31 | 379591.74 | 113126.35 | 0.00 | 0.00 | 153154.21 | 683760.01 |
| 2023-08 | 522805.38 | 221368.38 | 11929.73 | 43574.32 | 10734.81 | 51836.52 | 183361.62 |
| 2024-01 | 632205.51 | 232267.45 | 35579.42 | 0.00 | 0.00 | 35401.14 | 328957.50 |
| 2024-07 | 373482.95 | 131532.22 | 13575.83 | 0.00 | 0.00 | 54736.99 | 173637.91 |
| 2024-11 | 424854.79 | 179107.32 | 16287.42 | 0.00 | 0.00 | 59177.55 | 170282.50 |
| 2024-12 | 523917.45 | 222513.74 | 22868.10 | 0.00 | 0.00 | 69373.14 | 209162.47 |
| 2025-07 | 1049907.39 | 339444.17 | 64951.34 | 0.00 | 0.00 | 137693.96 | 507817.92 |
| 2025-08 | 1084046.19 | 341208.64 | 50025.34 | 0.00 | 0.00 | 153287.17 | 539525.04 |
| 2025-10 | 1685221.28 | 376710.13 | 120107.95 | 0.00 | 0.00 | 218710.30 | 969692.90 |
| 2025-12 | 1551065.56 | 435025.32 | 94138.65 | 0.00 | 0.00 | 210268.12 | 811633.47 |
| 2026-01 | 1512873.21 | 412304.50 | 86007.33 | 0.00 | 0.00 | 187016.76 | 827544.62 |
| 2026-02 | 1512800.09 | 411483.50 | 100314.81 | 0.00 | 0.00 | 177339.01 | 823662.77 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-05-30 17:22:51.290 UTC