[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 | 500586.66 | 218756.75 | 29617.80 | 29325.26 | 18907.99 | 51633.24 | 152345.62 |
| 2023-01 | 553514.82 | 218157.65 | 34123.45 | 44070.14 | 29642.80 | 27666.01 | 199854.77 |
| 2023-02 | 671943.55 | 251927.58 | 32700.25 | 44248.42 | 41254.99 | 47330.87 | 254481.44 |
| 2024-04 | 517796.71 | 219970.22 | 21473.41 | 0.00 | 0.00 | 67832.31 | 208520.77 |
| 2024-09 | 819104.30 | 240041.14 | 38966.46 | 0.00 | 0.00 | 123793.42 | 416303.28 |
| 2025-03 | 1388375.20 | 372868.11 | 128452.84 | 0.00 | 0.00 | 177394.50 | 709659.75 |
| 2025-10 | 7716.35 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 7716.35 |
| 2022-11 | 478531.72 | 172887.86 | 21266.34 | 32903.53 | 32496.97 | 58433.22 | 160543.80 |
| 2023-03 | 630432.00 | 222766.58 | 50413.32 | 18412.17 | 3578.27 | 75079.65 | 260182.01 |
| 2023-04 | 581297.89 | 193040.77 | 53788.31 | 0.00 | 0.00 | 54130.85 | 280337.96 |
| 2023-07 | 753116.55 | 219441.83 | 64027.30 | 0.00 | 0.00 | 32814.51 | 436832.91 |
| 2023-10 | 537406.72 | 154699.95 | 37797.58 | 0.00 | 0.00 | 63639.17 | 281270.02 |
| 2024-02 | 528432.58 | 180288.91 | 18450.20 | 0.00 | 0.00 | 67997.53 | 261695.94 |
| 2025-02 | 1536029.90 | 349756.63 | 94773.79 | 0.00 | 0.00 | 202436.47 | 889063.01 |
| 2025-04 | 1501194.27 | 417934.29 | 92373.23 | 0.00 | 0.00 | 179401.09 | 811485.66 |
| 2025-05 | 1486873.89 | 417111.51 | 84588.28 | 0.00 | 0.00 | 205211.60 | 779962.50 |
| 2025-06 | 1534980.79 | 411133.39 | 93482.73 | 0.00 | 0.00 | 176222.43 | 854142.24 |
| 2022-12 | 513596.81 | 212095.79 | 11230.63 | 36799.34 | 18590.45 | 62571.33 | 172309.27 |
| 2023-06 | 614264.16 | 217180.27 | 53470.77 | 0.00 | 0.00 | 32204.43 | 311408.69 |
| 2023-08 | 663506.28 | 206462.69 | 54690.69 | 0.00 | 0.00 | 39321.95 | 363030.95 |
| 2024-05 | 454486.51 | 182103.71 | 23995.60 | 0.00 | 0.00 | 61714.45 | 186672.75 |
| 2025-01 | 1217286.03 | 358755.55 | 91542.21 | 0.00 | 0.00 | 171466.76 | 595521.51 |
| 2024-12 | 1055869.51 | 338933.66 | 48168.40 | 0.00 | 0.00 | 148249.49 | 520517.96 |
| 2022-09 | 406500.23 | 188094.03 | 14313.08 | 32026.15 | 36100.24 | 33221.07 | 102745.66 |
| 2023-05 | 643531.65 | 229884.10 | 32001.15 | 0.00 | 0.00 | 32521.97 | 349124.43 |
| 2023-09 | 502289.88 | 124306.14 | 50490.90 | 0.00 | 0.00 | 41163.63 | 286329.21 |
| 2023-11 | 383981.19 | 128309.87 | 12271.64 | 0.00 | 0.00 | 48833.04 | 194566.64 |
| 2023-12 | 398399.29 | 175150.11 | 21339.45 | 0.00 | 0.00 | 51773.94 | 150135.79 |
| 2024-01 | 348983.03 | 113316.20 | 8448.05 | 0.00 | 0.00 | 47032.50 | 180186.28 |
| 2024-03 | 468358.36 | 200192.46 | 18357.79 | 0.00 | 0.00 | 70224.78 | 179583.33 |
| 2024-06 | 521046.02 | 217157.45 | 16196.92 | 0.00 | 0.00 | 48171.49 | 239520.16 |
| 2024-07 | 538646.46 | 194516.75 | 27811.21 | 0.00 | 0.00 | 66789.76 | 249528.74 |
| 2024-08 | 590803.32 | 212948.34 | 5986.37 | 0.00 | 0.00 | 60769.97 | 311098.64 |
| 2024-10 | 857653.16 | 182934.08 | 59640.60 | 0.00 | 0.00 | 130346.03 | 484732.45 |
| 2024-11 | 1025005.43 | 324444.30 | 62852.70 | 0.00 | 0.00 | 128241.17 | 509467.26 |
| 2025-07 | 1890583.28 | 445528.19 | 140828.71 | 0.00 | 0.00 | 213298.57 | 1090927.81 |
| 2025-08 | 2005187.41 | 505393.79 | 138936.15 | 0.00 | 0.00 | 261310.97 | 1099546.50 |
| 2025-09 | 231365.98 | 33497.57 | 17649.19 | 0.00 | 0.00 | 28105.55 | 152113.67 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-10-04 05:42:42.519 UTC