[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-08 | 952535.35 | 224943.79 | 57067.78 | 0.00 | 0.00 | 134018.47 | 536505.31 |
| 2022-10 | 499455.76 | 194218.46 | 28918.70 | 33602.63 | 25365.43 | 61287.39 | 156063.15 |
| 2023-06 | 711842.81 | 237804.00 | 64205.58 | 0.00 | 0.00 | 28715.42 | 381117.81 |
| 2024-02 | 478472.73 | 192350.60 | 20183.93 | 0.00 | 0.00 | 67032.64 | 198905.56 |
| 2024-07 | 579519.66 | 216367.17 | 15315.67 | 0.00 | 0.00 | 56775.84 | 291060.98 |
| 2025-03 | 1464412.87 | 427279.21 | 93459.29 | 0.00 | 0.00 | 187909.77 | 755764.60 |
| 2022-12 | 552879.74 | 235349.90 | 9253.84 | 52129.06 | 25543.71 | 31244.28 | 199358.95 |
| 2023-02 | 605176.10 | 196098.46 | 50591.60 | 22486.26 | 18590.45 | 54512.41 | 262896.92 |
| 2023-04 | 572133.31 | 201481.49 | 42735.96 | 0.00 | 0.00 | 14630.62 | 313285.24 |
| 2023-05 | 648292.10 | 226363.60 | 49689.22 | 0.00 | 0.00 | 46339.23 | 325900.05 |
| 2024-01 | 485309.16 | 159461.55 | 15086.77 | 0.00 | 0.00 | 69724.25 | 241036.59 |
| 2024-03 | 488650.50 | 204192.53 | 23262.35 | 0.00 | 0.00 | 62863.19 | 198332.43 |
| 2024-08 | 741914.12 | 237705.17 | 30872.74 | 0.00 | 0.00 | 97109.21 | 376227.00 |
| 2025-01 | 1582290.02 | 377812.39 | 99534.81 | 0.00 | 0.00 | 239908.18 | 865034.64 |
| 2025-07 | 1933222.45 | 470128.23 | 143739.17 | 0.00 | 0.00 | 228598.67 | 1090756.38 |
| 2022-08 | 227411.25 | 92232.88 | 3578.27 | 21469.62 | 14134.80 | 22689.54 | 73306.14 |
| 2022-09 | 491750.36 | 239092.43 | 25543.71 | 32026.15 | 33196.07 | 33920.17 | 127971.83 |
| 2023-01 | 625558.81 | 235745.48 | 43955.88 | 47127.59 | 37498.44 | 40174.33 | 221057.09 |
| 2023-07 | 616918.26 | 200837.12 | 40199.33 | 0.00 | 0.00 | 36621.06 | 339260.75 |
| 2023-08 | 643109.68 | 166706.98 | 63303.37 | 0.00 | 0.00 | 39644.30 | 373455.03 |
| 2024-04 | 489994.23 | 203904.88 | 20058.33 | 0.00 | 0.00 | 64329.09 | 201701.93 |
| 2024-05 | 520153.55 | 209339.99 | 21400.30 | 0.00 | 0.00 | 56657.51 | 232755.75 |
| 2024-06 | 502687.72 | 192294.80 | 20531.01 | 0.00 | 0.00 | 59680.85 | 230181.06 |
| 2024-11 | 1037402.15 | 339000.52 | 70602.87 | 0.00 | 0.00 | 130341.37 | 497457.39 |
| 2024-12 | 1110853.96 | 338625.30 | 69120.65 | 0.00 | 0.00 | 137350.09 | 565757.92 |
| 2025-02 | 1365201.91 | 349620.43 | 122807.45 | 0.00 | 0.00 | 163915.53 | 728858.50 |
| 2025-04 | 1452499.24 | 395066.71 | 82943.87 | 0.00 | 0.00 | 185615.42 | 788873.24 |
| 2025-06 | 1788937.63 | 459769.57 | 126735.34 | 0.00 | 0.00 | 211311.04 | 991121.68 |
| 2022-11 | 527375.05 | 201742.54 | 14109.80 | 28943.70 | 26242.81 | 76527.85 | 179808.35 |
| 2023-03 | 636381.36 | 213162.43 | 50235.04 | 0.00 | 0.00 | 86310.28 | 286673.61 |
| 2023-09 | 481562.80 | 127261.38 | 40134.67 | 0.00 | 0.00 | 45525.48 | 268641.27 |
| 2023-10 | 469862.73 | 146609.06 | 22000.70 | 0.00 | 0.00 | 67985.14 | 233267.83 |
| 2023-11 | 366291.45 | 157043.54 | 13819.48 | 0.00 | 0.00 | 51869.18 | 143559.25 |
| 2023-12 | 379577.65 | 138428.55 | 15365.71 | 0.00 | 0.00 | 42583.83 | 183199.56 |
| 2024-09 | 822049.77 | 198624.50 | 43273.03 | 0.00 | 0.00 | 140335.57 | 439816.67 |
| 2024-10 | 976796.05 | 254314.88 | 57766.44 | 0.00 | 0.00 | 130881.78 | 533832.95 |
| 2025-05 | 1506140.27 | 391007.70 | 95114.84 | 0.00 | 0.00 | 183410.74 | 836606.99 |
| 2025-09 | 24055.33 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 24055.33 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-09-14 05:19:51.986 UTC