[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-10 | 535890.77 | 221939.20 | 16410.38 | 52129.06 | 25543.71 | 31244.28 | 188624.14 |
| 2023-12 | 670830.12 | 233012.06 | 54169.87 | 22486.26 | 15012.18 | 68622.21 | 277527.54 |
| 2024-05 | 627901.86 | 208896.04 | 47534.15 | 0.00 | 0.00 | 36799.34 | 334672.33 |
| 2024-11 | 506224.64 | 167535.18 | 15086.77 | 0.00 | 0.00 | 66759.70 | 256842.99 |
| 2025-06 | 721155.76 | 237923.77 | 30872.74 | 0.00 | 0.00 | 91738.89 | 360620.36 |
| 2026-07 | 22690.93 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 22690.93 |
| 2026-03 | 1515052.84 | 395984.29 | 90715.71 | 0.00 | 0.00 | 192196.73 | 836156.11 |
| 2023-06 | 234364.51 | 99186.14 | 3578.27 | 21469.62 | 14134.80 | 22689.54 | 73306.14 |
| 2023-11 | 625037.99 | 235224.66 | 36799.34 | 43549.32 | 41076.71 | 43752.60 | 224635.36 |
| 2024-01 | 599874.32 | 184104.47 | 50235.04 | 0.00 | 0.00 | 68622.21 | 296912.60 |
| 2024-02 | 581551.41 | 200604.11 | 39157.69 | 0.00 | 0.00 | 25187.15 | 316602.46 |
| 2024-04 | 722017.78 | 244553.98 | 64027.30 | 0.00 | 0.00 | 32115.41 | 381321.09 |
| 2024-08 | 454271.23 | 142142.06 | 10967.45 | 0.00 | 0.00 | 64803.14 | 236358.58 |
| 2025-02 | 463235.99 | 183682.68 | 20080.65 | 0.00 | 0.00 | 63546.10 | 195926.56 |
| 2025-03 | 503914.05 | 211902.87 | 19328.88 | 0.00 | 0.00 | 52142.74 | 220539.56 |
| 2025-04 | 487230.20 | 180579.31 | 20531.01 | 0.00 | 0.00 | 57893.54 | 228226.34 |
| 2025-05 | 599877.11 | 212136.51 | 15315.67 | 0.00 | 0.00 | 63339.71 | 309085.22 |
| 2025-10 | 1108662.86 | 332155.50 | 72390.40 | 0.00 | 0.00 | 138591.60 | 565525.36 |
| 2026-05 | 1960386.55 | 476223.35 | 145957.25 | 0.00 | 0.00 | 242372.06 | 1095833.89 |
| 2023-08 | 506459.02 | 198000.01 | 25340.43 | 33602.63 | 25365.43 | 68265.65 | 155884.87 |
| 2023-09 | 534506.59 | 212095.79 | 14109.80 | 32521.97 | 26242.81 | 69549.59 | 179986.63 |
| 2024-06 | 582819.90 | 148533.93 | 52108.35 | 0.00 | 0.00 | 36066.03 | 346111.59 |
| 2024-07 | 513690.28 | 140959.01 | 44471.59 | 0.00 | 0.00 | 48707.48 | 279552.20 |
| 2024-09 | 369091.66 | 160199.62 | 15890.90 | 0.00 | 0.00 | 52869.62 | 140131.52 |
| 2024-12 | 483761.68 | 191515.04 | 25070.63 | 0.00 | 0.00 | 72657.99 | 194518.02 |
| 2025-07 | 880663.30 | 208468.86 | 55998.24 | 0.00 | 0.00 | 152670.69 | 463525.51 |
| 2025-11 | 1563229.46 | 363671.75 | 94405.89 | 0.00 | 0.00 | 238333.05 | 866818.77 |
| 2026-01 | 1523532.45 | 430326.83 | 100508.19 | 0.00 | 0.00 | 191661.79 | 801035.64 |
| 2026-06 | 824811.86 | 196024.66 | 46403.20 | 0.00 | 0.00 | 114224.40 | 468159.60 |
| 2026-04 | 1778245.21 | 453866.26 | 130268.09 | 0.00 | 0.00 | 199354.03 | 994756.83 |
| 2023-07 | 509641.71 | 239092.43 | 29121.98 | 32026.15 | 33196.07 | 33920.17 | 142284.91 |
| 2024-03 | 653504.62 | 222785.33 | 60424.03 | 0.00 | 0.00 | 35782.70 | 334512.56 |
| 2024-10 | 361416.02 | 128004.90 | 13294.29 | 0.00 | 0.00 | 46597.04 | 173519.79 |
| 2025-01 | 511752.15 | 223453.59 | 20424.75 | 0.00 | 0.00 | 64717.16 | 203156.65 |
| 2025-08 | 990343.28 | 268642.44 | 54503.29 | 0.00 | 0.00 | 123827.34 | 543370.21 |
| 2025-09 | 1032503.12 | 346924.63 | 65712.03 | 0.00 | 0.00 | 134014.76 | 485851.70 |
| 2025-12 | 1440089.45 | 382892.16 | 130700.69 | 0.00 | 0.00 | 168333.63 | 758162.97 |
| 2026-02 | 1358445.21 | 368744.80 | 74602.56 | 0.00 | 0.00 | 174379.65 | 740718.20 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-07-13 17:01:16.622 UTC