[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-12 | 1490088.50 | 406132.50 | 92437.89 | 0.00 | 0.00 | 191830.30 | 799687.81 |
| 2023-05 | 494832.81 | 248974.86 | 21965.44 | 32026.15 | 43930.88 | 34797.55 | 113137.93 |
| 2023-09 | 598177.57 | 249969.54 | 40377.61 | 36417.78 | 47330.87 | 30545.18 | 193536.59 |
| 2023-11 | 602422.17 | 233169.83 | 43281.78 | 0.00 | 0.00 | 75232.93 | 250737.63 |
| 2024-03 | 679789.90 | 231885.89 | 50730.86 | 0.00 | 0.00 | 43078.50 | 354094.65 |
| 2024-10 | 550149.45 | 212170.49 | 23255.79 | 0.00 | 0.00 | 64961.22 | 249761.95 |
| 2025-01 | 495806.30 | 197932.15 | 22578.59 | 0.00 | 0.00 | 62725.33 | 212570.23 |
| 2025-05 | 869816.46 | 237084.37 | 44384.32 | 0.00 | 0.00 | 131970.46 | 456377.31 |
| 2025-07 | 1052446.12 | 336628.64 | 59149.18 | 0.00 | 0.00 | 132319.31 | 524348.99 |
| 2025-08 | 1111155.27 | 358555.13 | 68936.42 | 0.00 | 0.00 | 136834.58 | 546829.14 |
| 2023-08 | 536126.82 | 209984.47 | 12628.83 | 61961.49 | 11433.91 | 37701.72 | 202416.40 |
| 2023-10 | 681578.95 | 218623.74 | 47013.33 | 37295.16 | 22867.82 | 64662.38 | 291116.52 |
| 2023-12 | 610680.92 | 179580.07 | 53267.49 | 0.00 | 0.00 | 36442.78 | 341390.58 |
| 2024-01 | 624998.97 | 228639.18 | 38954.41 | 0.00 | 0.00 | 39182.69 | 318222.69 |
| 2024-04 | 612881.78 | 166990.83 | 63653.44 | 0.00 | 0.00 | 29655.88 | 352581.63 |
| 2024-06 | 481139.52 | 140634.10 | 26104.41 | 0.00 | 0.00 | 61904.39 | 252496.62 |
| 2024-08 | 401606.57 | 171294.62 | 17437.13 | 0.00 | 0.00 | 45060.80 | 167814.02 |
| 2024-12 | 514260.86 | 224002.04 | 20819.00 | 0.00 | 0.00 | 58501.04 | 210938.78 |
| 2025-03 | 559218.60 | 212359.86 | 18365.21 | 0.00 | 0.00 | 62896.49 | 265597.04 |
| 2026-01 | 1525786.80 | 411837.76 | 82469.16 | 0.00 | 0.00 | 181846.20 | 849633.68 |
| 2023-04 | 116523.90 | 42875.22 | 3578.27 | 10734.81 | 3399.99 | 14833.90 | 41101.71 |
| 2023-07 | 482548.04 | 197896.73 | 10734.81 | 18590.45 | 33399.35 | 63587.97 | 158338.73 |
| 2024-02 | 681347.63 | 222816.82 | 60830.59 | 0.00 | 0.00 | 28715.42 | 368984.80 |
| 2024-05 | 503182.97 | 127348.45 | 39611.09 | 0.00 | 0.00 | 48910.48 | 287312.95 |
| 2024-09 | 409906.34 | 127525.83 | 12014.91 | 0.00 | 0.00 | 65628.43 | 204737.17 |
| 2025-06 | 888684.83 | 202764.82 | 65110.12 | 0.00 | 0.00 | 134346.32 | 486463.57 |
| 2025-09 | 1373101.07 | 352796.87 | 79713.29 | 0.00 | 0.00 | 207270.15 | 733320.76 |
| 2025-10 | 1590100.06 | 347857.49 | 139519.78 | 0.00 | 0.00 | 202492.71 | 900230.08 |
| 2025-11 | 1418716.98 | 443861.32 | 93050.00 | 0.00 | 0.00 | 181223.96 | 700581.70 |
| 2026-03 | 1871498.37 | 452431.53 | 150761.92 | 0.00 | 0.00 | 210374.95 | 1057929.97 |
| 2026-05 | 36557.15 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 36557.15 |
| 2026-02 | 1600917.53 | 406435.16 | 115578.16 | 0.00 | 0.00 | 194637.01 | 884267.20 |
| 2026-04 | 1411598.09 | 336917.11 | 85580.31 | 0.00 | 0.00 | 198345.69 | 790754.98 |
| 2023-06 | 509516.47 | 183979.47 | 32496.97 | 40759.17 | 18208.89 | 63492.46 | 170579.51 |
| 2024-07 | 365520.23 | 137677.14 | 14974.40 | 0.00 | 0.00 | 52263.43 | 160605.26 |
| 2024-11 | 465648.01 | 188756.28 | 18358.84 | 0.00 | 0.00 | 68773.85 | 189759.04 |
| 2025-02 | 491570.53 | 180591.12 | 20446.02 | 0.00 | 0.00 | 53692.66 | 236840.73 |
| 2025-04 | 648775.35 | 223006.79 | 16347.73 | 0.00 | 0.00 | 77610.60 | 331810.23 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-05-22 13:44:05.425 UTC