[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-11 | 1020713.24 | 340742.70 | 54038.35 | 0.00 | 0.00 | 139211.50 | 486720.69 |
| 2023-09 | 486655.14 | 214351.10 | 26242.81 | 29325.26 | 22461.26 | 41076.71 | 153198.00 |
| 2023-12 | 543211.57 | 225339.19 | 23388.64 | 44273.42 | 33221.07 | 28365.11 | 188624.14 |
| 2024-02 | 591962.43 | 216487.42 | 43435.06 | 18412.17 | 7855.64 | 75079.65 | 230692.49 |
| 2025-01 | 543088.16 | 180003.00 | 21016.62 | 0.00 | 0.00 | 69219.11 | 272849.43 |
| 2025-03 | 514059.61 | 228709.84 | 20424.75 | 0.00 | 0.00 | 64717.16 | 200207.86 |
| 2025-06 | 513987.88 | 195386.30 | 20531.01 | 0.00 | 0.00 | 64125.08 | 233945.49 |
| 2025-10 | 1040432.24 | 292135.19 | 66665.72 | 0.00 | 0.00 | 133068.79 | 548562.54 |
| 2026-09 | 15832.23 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 15832.23 |
| 2026-03 | 1545496.72 | 434499.43 | 98783.56 | 0.00 | 0.00 | 184838.48 | 827375.25 |
| 2023-11 | 526689.97 | 208695.80 | 10531.53 | 36799.34 | 18590.45 | 69028.77 | 183044.08 |
| 2025-05 | 498708.10 | 205822.12 | 20594.99 | 0.00 | 0.00 | 52540.87 | 219750.12 |
| 2026-07 | 1972871.34 | 500842.86 | 138966.31 | 0.00 | 0.00 | 245569.90 | 1087492.27 |
| 2026-08 | 609262.49 | 133907.09 | 36456.75 | 0.00 | 0.00 | 76849.30 | 362049.35 |
| 2024-03 | 593416.88 | 181924.40 | 50235.04 | 0.00 | 0.00 | 54309.13 | 306948.31 |
| 2024-07 | 632700.05 | 209595.14 | 51112.42 | 0.00 | 0.00 | 29642.80 | 342349.69 |
| 2024-09 | 502988.46 | 146102.29 | 37797.58 | 0.00 | 0.00 | 52933.51 | 266155.08 |
| 2024-10 | 422186.18 | 130709.63 | 13149.01 | 0.00 | 0.00 | 52248.25 | 226079.29 |
| 2024-11 | 386272.51 | 164954.91 | 20073.34 | 0.00 | 0.00 | 57617.60 | 143626.66 |
| 2024-12 | 349224.53 | 125980.95 | 7930.73 | 0.00 | 0.00 | 46209.05 | 169103.80 |
| 2025-02 | 427983.92 | 175950.21 | 18140.34 | 0.00 | 0.00 | 65706.13 | 168187.24 |
| 2025-08 | 782075.45 | 244985.82 | 35835.90 | 0.00 | 0.00 | 107822.32 | 393431.41 |
| 2026-01 | 1661264.72 | 384388.34 | 102818.62 | 0.00 | 0.00 | 245959.86 | 928097.90 |
| 2026-04 | 1432438.73 | 390042.27 | 86247.91 | 0.00 | 0.00 | 193291.99 | 762856.56 |
| 2023-08 | 323743.22 | 145689.63 | 7156.54 | 28447.88 | 24869.61 | 26064.53 | 91515.03 |
| 2023-10 | 495100.11 | 193950.92 | 28219.60 | 32903.53 | 33017.79 | 65411.48 | 141596.79 |
| 2024-01 | 689428.34 | 248349.31 | 44134.16 | 47623.41 | 40555.89 | 47330.87 | 261434.70 |
| 2024-04 | 614994.51 | 227093.95 | 42532.68 | 0.00 | 0.00 | 28765.42 | 316602.46 |
| 2024-05 | 648420.38 | 227012.70 | 57049.04 | 0.00 | 0.00 | 32204.43 | 332154.21 |
| 2024-06 | 723880.31 | 222995.10 | 60449.03 | 0.00 | 0.00 | 39271.95 | 401164.23 |
| 2024-08 | 586086.28 | 139762.18 | 55204.09 | 0.00 | 0.00 | 46576.45 | 344543.56 |
| 2025-04 | 478714.18 | 183847.26 | 20863.64 | 0.00 | 0.00 | 63280.43 | 210722.85 |
| 2025-07 | 595333.12 | 212787.04 | 14049.56 | 0.00 | 0.00 | 61379.29 | 307117.23 |
| 2025-09 | 831412.88 | 192135.72 | 50817.74 | 0.00 | 0.00 | 132586.75 | 455872.67 |
| 2025-12 | 1132118.94 | 343213.62 | 81188.05 | 0.00 | 0.00 | 140735.36 | 566981.91 |
| 2026-02 | 1278239.75 | 335210.68 | 115190.33 | 0.00 | 0.00 | 156206.29 | 671632.45 |
| 2026-05 | 1524743.03 | 404127.13 | 92301.11 | 0.00 | 0.00 | 185825.63 | 842489.16 |
| 2026-06 | 1822940.29 | 444256.98 | 132944.94 | 0.00 | 0.00 | 213279.77 | 1032458.60 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-09-09 05:10:57.342 UTC