[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-11 | 1542989.83 | 371680.61 | 95054.73 | 0.00 | 0.00 | 233312.98 | 842941.51 |
| 2023-06 | 227411.25 | 92232.88 | 3578.27 | 21469.62 | 14134.80 | 22689.54 | 73306.14 |
| 2023-10 | 553782.12 | 236252.28 | 9253.84 | 55707.33 | 25543.71 | 31244.28 | 195780.68 |
| 2026-01 | 1516664.57 | 432223.17 | 102798.92 | 0.00 | 0.00 | 188797.39 | 792845.09 |
| 2025-12 | 1468877.66 | 387074.23 | 128567.68 | 0.00 | 0.00 | 177297.30 | 775938.45 |
| 2023-11 | 614124.90 | 231468.11 | 43955.88 | 43549.32 | 37498.44 | 40174.33 | 217478.82 |
| 2026-02 | 1342875.45 | 364293.58 | 73809.71 | 0.00 | 0.00 | 176373.59 | 728398.57 |
| 2023-12 | 676588.46 | 235192.13 | 54169.87 | 22486.26 | 18590.45 | 61465.67 | 284684.08 |
| 2023-08 | 509834.01 | 194218.46 | 28918.70 | 33602.63 | 25365.43 | 64687.38 | 163041.41 |
| 2024-07 | 505268.09 | 140848.87 | 43361.01 | 0.00 | 0.00 | 48707.48 | 272350.73 |
| 2024-03 | 653707.90 | 226363.60 | 60424.03 | 0.00 | 0.00 | 35782.70 | 331137.57 |
| 2024-11 | 485117.65 | 156740.65 | 15086.77 | 0.00 | 0.00 | 68941.26 | 244348.97 |
| 2024-04 | 717918.69 | 237779.00 | 64027.30 | 0.00 | 0.00 | 32115.41 | 383996.98 |
| 2025-01 | 502047.79 | 221705.41 | 20424.75 | 0.00 | 0.00 | 66377.52 | 193540.11 |
| 2024-08 | 463612.30 | 142142.06 | 16592.80 | 0.00 | 0.00 | 64803.14 | 240074.30 |
| 2025-03 | 512718.57 | 213576.16 | 19328.88 | 0.00 | 0.00 | 56263.26 | 223550.27 |
| 2024-09 | 361964.03 | 148971.71 | 13819.48 | 0.00 | 0.00 | 51869.18 | 147303.66 |
| 2025-06 | 726980.63 | 235656.07 | 30872.74 | 0.00 | 0.00 | 90151.09 | 370300.73 |
| 2025-02 | 462459.71 | 184058.49 | 20080.65 | 0.00 | 0.00 | 60208.57 | 198112.00 |
| 2025-08 | 965066.37 | 259312.38 | 58562.72 | 0.00 | 0.00 | 124185.73 | 523005.54 |
| 2025-05 | 589828.24 | 216234.71 | 15315.67 | 0.00 | 0.00 | 63733.96 | 294543.90 |
| 2026-06 | 881534.95 | 207254.85 | 51479.75 | 0.00 | 0.00 | 119261.57 | 503538.78 |
| 2025-07 | 865870.90 | 207402.02 | 45964.21 | 0.00 | 0.00 | 149561.01 | 462943.66 |
| 2026-07 | 24055.33 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 24055.33 |
| 2026-04 | 1797875.32 | 468992.25 | 129698.12 | 0.00 | 0.00 | 209776.63 | 989408.32 |
| 2026-05 | 1949989.57 | 470525.64 | 144217.88 | 0.00 | 0.00 | 240489.77 | 1094756.28 |
| 2023-07 | 495328.63 | 242670.70 | 25543.71 | 32026.15 | 33196.07 | 33920.17 | 127971.83 |
| 2023-09 | 523950.06 | 201539.26 | 14109.80 | 28943.70 | 26242.81 | 73127.86 | 179986.63 |
| 2024-01 | 608429.06 | 189080.94 | 46656.77 | 0.00 | 0.00 | 79357.02 | 293334.33 |
| 2024-02 | 577274.04 | 197025.84 | 42735.96 | 0.00 | 0.00 | 25187.15 | 312325.09 |
| 2024-05 | 602878.97 | 208514.48 | 33221.07 | 0.00 | 0.00 | 33221.07 | 327922.35 |
| 2024-06 | 607996.42 | 153619.05 | 61906.66 | 0.00 | 0.00 | 39644.30 | 352826.41 |
| 2024-10 | 375498.34 | 141414.37 | 15365.71 | 0.00 | 0.00 | 45415.92 | 173302.34 |
| 2024-12 | 502752.91 | 197383.74 | 25070.63 | 0.00 | 0.00 | 70214.64 | 210083.90 |
| 2025-04 | 484808.12 | 181106.02 | 20531.01 | 0.00 | 0.00 | 55450.19 | 227720.90 |
| 2025-09 | 1050960.79 | 344634.60 | 70074.97 | 0.00 | 0.00 | 130997.25 | 505253.97 |
| 2025-10 | 1104504.06 | 325347.98 | 70641.17 | 0.00 | 0.00 | 140760.02 | 567754.89 |
| 2026-03 | 1505132.20 | 387451.92 | 91295.68 | 0.00 | 0.00 | 182783.39 | 843601.21 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-07-14 10:19:02.209 UTC