[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-09 | 1878989.17 | 452836.70 | 138629.85 | 0.00 | 0.00 | 225732.87 | 1061789.75 |
| 2023-06 | 572133.31 | 201481.49 | 42735.96 | 0.00 | 0.00 | 14630.62 | 313285.24 |
| 2023-09 | 585273.67 | 197462.13 | 36621.06 | 0.00 | 0.00 | 33221.07 | 317969.41 |
| 2024-09 | 574894.75 | 214185.61 | 15315.67 | 0.00 | 0.00 | 56775.84 | 288617.63 |
| 2023-01 | 537906.58 | 205117.53 | 14109.80 | 28943.70 | 26242.81 | 76527.85 | 186964.89 |
| 2023-03 | 632715.35 | 239323.75 | 43955.88 | 40174.33 | 37498.44 | 40174.33 | 231588.62 |
| 2023-07 | 648292.10 | 226363.60 | 49689.22 | 0.00 | 0.00 | 46339.23 | 325900.05 |
| 2023-08 | 743487.40 | 241178.99 | 67783.85 | 0.00 | 0.00 | 32115.41 | 402409.15 |
| 2023-10 | 643109.68 | 166706.98 | 63303.37 | 0.00 | 0.00 | 39644.30 | 373455.03 |
| 2024-03 | 482412.79 | 153642.59 | 15086.77 | 0.00 | 0.00 | 69986.04 | 243697.39 |
| 2024-05 | 488650.50 | 204192.53 | 23262.35 | 0.00 | 0.00 | 62863.19 | 198332.43 |
| 2024-08 | 507312.63 | 194476.36 | 20531.01 | 0.00 | 0.00 | 59680.85 | 232624.41 |
| 2024-11 | 822049.77 | 198624.50 | 43273.03 | 0.00 | 0.00 | 140335.57 | 439816.67 |
| 2025-03 | 1545156.53 | 374611.30 | 94350.08 | 0.00 | 0.00 | 223978.08 | 852217.07 |
| 2025-04 | 1482025.08 | 371960.22 | 132887.01 | 0.00 | 0.00 | 187693.78 | 789484.07 |
| 2025-06 | 1452499.24 | 395066.71 | 82943.87 | 0.00 | 0.00 | 185615.42 | 788873.24 |
| 2025-08 | 1843170.91 | 477061.10 | 131844.66 | 0.00 | 0.00 | 214176.84 | 1020088.31 |
| 2025-11 | 24055.33 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 24055.33 |
| 2022-10 | 227411.25 | 92232.88 | 3578.27 | 21469.62 | 14134.80 | 22689.54 | 73306.14 |
| 2022-11 | 491750.36 | 239092.43 | 25543.71 | 32026.15 | 33196.07 | 33920.17 | 127971.83 |
| 2022-12 | 499455.76 | 194218.46 | 28918.70 | 33602.63 | 25365.43 | 61287.39 | 156063.15 |
| 2023-02 | 501995.60 | 210009.47 | 9253.84 | 52129.06 | 25543.71 | 31244.28 | 173815.24 |
| 2023-11 | 481562.80 | 127261.38 | 40134.67 | 0.00 | 0.00 | 45525.48 | 268641.27 |
| 2023-12 | 469862.73 | 146609.06 | 22000.70 | 0.00 | 0.00 | 67985.14 | 233267.83 |
| 2024-02 | 353261.30 | 135246.55 | 15365.71 | 0.00 | 0.00 | 40140.48 | 162508.56 |
| 2024-04 | 496740.32 | 201351.56 | 20183.93 | 0.00 | 0.00 | 69214.20 | 205990.63 |
| 2024-06 | 489994.23 | 203904.88 | 20058.33 | 0.00 | 0.00 | 64329.09 | 201701.93 |
| 2024-07 | 520153.55 | 209339.99 | 21400.30 | 0.00 | 0.00 | 56657.51 | 232755.75 |
| 2024-10 | 741914.12 | 237705.17 | 30872.74 | 0.00 | 0.00 | 97109.21 | 376227.00 |
| 2024-12 | 976796.05 | 254314.88 | 57766.44 | 0.00 | 0.00 | 130881.78 | 533832.95 |
| 2025-01 | 1083052.24 | 358409.62 | 73562.43 | 0.00 | 0.00 | 133526.64 | 517553.55 |
| 2025-02 | 985514.19 | 300077.50 | 61266.26 | 0.00 | 0.00 | 126316.67 | 497853.76 |
| 2023-04 | 638372.17 | 214485.63 | 50591.60 | 29439.52 | 18590.45 | 54512.41 | 270752.56 |
| 2023-05 | 636381.36 | 213162.43 | 50235.04 | 0.00 | 0.00 | 86310.28 | 286673.61 |
| 2024-01 | 377236.58 | 157043.54 | 13819.48 | 0.00 | 0.00 | 51869.18 | 154504.38 |
| 2025-05 | 1464412.87 | 427279.21 | 93459.29 | 0.00 | 0.00 | 187909.77 | 755764.60 |
| 2025-07 | 1506140.27 | 391007.70 | 95114.84 | 0.00 | 0.00 | 183410.74 | 836606.99 |
| 2025-10 | 952535.35 | 224943.79 | 57067.78 | 0.00 | 0.00 | 134018.47 | 536505.31 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-11-14 06:21:19.043 UTC