[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-06 | 213276.45 | 81676.35 | 3578.27 | 21469.62 | 14134.80 | 22689.54 | 69727.87 |
| 2024-06 | 624519.23 | 155972.17 | 59725.10 | 0.00 | 0.00 | 39644.30 | 369177.66 |
| 2024-11 | 476547.97 | 156497.00 | 15086.77 | 0.00 | 0.00 | 66892.16 | 238072.04 |
| 2025-02 | 456959.81 | 188835.05 | 18009.23 | 0.00 | 0.00 | 57655.08 | 192460.45 |
| 2026-01 | 1488350.19 | 430958.50 | 99164.73 | 0.00 | 0.00 | 191253.05 | 766973.91 |
| 2026-03 | 1506140.27 | 391007.70 | 95114.84 | 0.00 | 0.00 | 183410.74 | 836606.99 |
| 2023-10 | 552879.74 | 235349.90 | 9253.84 | 52129.06 | 25543.71 | 31244.28 | 199358.95 |
| 2024-02 | 568719.30 | 200604.11 | 42735.96 | 0.00 | 0.00 | 18030.61 | 307348.62 |
| 2024-03 | 654407.00 | 219207.06 | 56845.76 | 0.00 | 0.00 | 42939.24 | 335414.94 |
| 2024-08 | 461341.76 | 144168.84 | 16592.80 | 0.00 | 0.00 | 67985.14 | 232594.98 |
| 2024-12 | 509577.24 | 200746.42 | 22627.28 | 0.00 | 0.00 | 70082.18 | 216121.36 |
| 2025-03 | 520153.55 | 209339.99 | 21400.30 | 0.00 | 0.00 | 56657.51 | 232755.75 |
| 2025-05 | 579519.66 | 216367.17 | 15315.67 | 0.00 | 0.00 | 56775.84 | 291060.98 |
| 2025-06 | 725049.95 | 235979.19 | 30872.74 | 0.00 | 0.00 | 88960.22 | 369237.80 |
| 2025-08 | 976796.05 | 254314.88 | 57766.44 | 0.00 | 0.00 | 130881.78 | 533832.95 |
| 2026-07 | 25983.27 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 25983.27 |
| 2025-12 | 1506630.28 | 384073.54 | 133320.33 | 0.00 | 0.00 | 187537.70 | 801698.71 |
| 2023-07 | 505885.16 | 249648.96 | 25543.71 | 32026.15 | 33196.07 | 33920.17 | 131550.10 |
| 2023-09 | 527375.05 | 201742.54 | 14109.80 | 28943.70 | 26242.81 | 76527.85 | 179808.35 |
| 2023-12 | 662453.66 | 232491.24 | 54169.87 | 22486.26 | 18590.45 | 61465.67 | 273250.17 |
| 2024-01 | 619481.41 | 195855.92 | 46656.77 | 0.00 | 0.00 | 79357.02 | 297611.70 |
| 2024-07 | 499810.45 | 137246.72 | 45542.57 | 0.00 | 0.00 | 45525.48 | 271495.68 |
| 2024-10 | 377393.71 | 141393.10 | 15365.71 | 0.00 | 0.00 | 45415.92 | 175218.98 |
| 2025-01 | 490580.41 | 210866.54 | 22868.10 | 0.00 | 0.00 | 66487.66 | 190358.11 |
| 2026-05 | 1933222.45 | 470128.23 | 143739.17 | 0.00 | 0.00 | 228598.67 | 1090756.38 |
| 2026-06 | 950607.41 | 224943.79 | 57067.78 | 0.00 | 0.00 | 134018.47 | 534577.37 |
| 2026-04 | 1788937.63 | 459769.57 | 126735.34 | 0.00 | 0.00 | 211311.04 | 991121.68 |
| 2023-08 | 499455.76 | 194218.46 | 28918.70 | 33602.63 | 25365.43 | 61287.39 | 156063.15 |
| 2023-11 | 614328.18 | 228093.12 | 43955.88 | 47127.59 | 37498.44 | 40174.33 | 217478.82 |
| 2024-04 | 711639.53 | 237779.00 | 60627.31 | 0.00 | 0.00 | 32115.41 | 381117.81 |
| 2024-05 | 603864.12 | 208196.94 | 40199.33 | 0.00 | 0.00 | 33221.07 | 322246.78 |
| 2024-09 | 367509.90 | 149498.42 | 13819.48 | 0.00 | 0.00 | 51869.18 | 152322.82 |
| 2025-04 | 502687.72 | 192294.80 | 20531.01 | 0.00 | 0.00 | 59680.85 | 230181.06 |
| 2025-07 | 838913.94 | 200350.48 | 43273.03 | 0.00 | 0.00 | 148484.56 | 446805.87 |
| 2025-09 | 1037402.15 | 339000.52 | 70602.87 | 0.00 | 0.00 | 130341.37 | 497457.39 |
| 2025-10 | 1110853.96 | 338625.30 | 69120.65 | 0.00 | 0.00 | 137350.09 | 565757.92 |
| 2025-11 | 1515211.26 | 370321.44 | 93868.29 | 0.00 | 0.00 | 221530.34 | 829491.19 |
| 2026-02 | 1354212.31 | 364425.26 | 72392.07 | 0.00 | 0.00 | 177027.81 | 740367.17 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-07-15 10:26:15.525 UTC