[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-05 | 648343.86 | 216983.24 | 50591.60 | 22486.26 | 11433.91 | 75778.75 | 271070.10 |
| 2023-06 | 581283.87 | 180526.20 | 50235.04 | 0.00 | 0.00 | 57887.40 | 292635.23 |
| 2023-08 | 655170.36 | 233787.68 | 56845.76 | 0.00 | 0.00 | 32204.43 | 332332.49 |
| 2023-09 | 716748.77 | 215838.56 | 64027.30 | 0.00 | 0.00 | 35693.68 | 401189.23 |
| 2023-11 | 572213.48 | 142555.60 | 55204.09 | 0.00 | 0.00 | 40296.69 | 334157.10 |
| 2024-03 | 363577.17 | 133435.12 | 10112.29 | 0.00 | 0.00 | 44030.62 | 175999.14 |
| 2024-04 | 514530.43 | 172306.23 | 17918.86 | 0.00 | 0.00 | 67760.14 | 256545.20 |
| 2025-03 | 1113327.39 | 332726.26 | 74703.29 | 0.00 | 0.00 | 135000.38 | 570897.46 |
| 2025-09 | 1822940.29 | 444256.98 | 132944.94 | 0.00 | 0.00 | 213279.77 | 1032458.60 |
| 2025-08 | 1524743.03 | 404127.13 | 92301.11 | 0.00 | 0.00 | 185825.63 | 842489.16 |
| 2024-08 | 498708.10 | 205822.12 | 20594.99 | 0.00 | 0.00 | 52540.87 | 219750.12 |
| 2022-11 | 285501.93 | 131733.11 | 7156.54 | 25047.89 | 17713.07 | 22689.54 | 81161.78 |
| 2025-01 | 1040432.24 | 292135.19 | 66665.72 | 0.00 | 0.00 | 133068.79 | 548562.54 |
| 2022-12 | 524896.43 | 228307.62 | 26242.81 | 32725.25 | 29617.80 | 44451.70 | 163551.25 |
| 2025-05 | 1431710.99 | 374118.66 | 126402.49 | 0.00 | 0.00 | 178482.48 | 752707.36 |
| 2023-01 | 495100.11 | 193950.92 | 28219.60 | 32903.53 | 33017.79 | 65411.48 | 141596.79 |
| 2025-06 | 1463952.23 | 416832.40 | 97753.77 | 0.00 | 0.00 | 177128.20 | 772237.86 |
| 2023-07 | 627712.36 | 228873.71 | 42735.96 | 0.00 | 0.00 | 28765.42 | 327337.27 |
| 2025-07 | 1513983.22 | 407709.30 | 87277.70 | 0.00 | 0.00 | 201002.27 | 817993.95 |
| 2023-12 | 514292.89 | 146234.75 | 37797.58 | 0.00 | 0.00 | 57031.71 | 273228.85 |
| 2024-02 | 362660.25 | 159682.30 | 16891.34 | 0.00 | 0.00 | 53254.48 | 132832.13 |
| 2024-05 | 474129.38 | 185828.54 | 22238.54 | 0.00 | 0.00 | 73706.65 | 192355.65 |
| 2024-07 | 496198.48 | 195667.38 | 20863.64 | 0.00 | 0.00 | 65329.53 | 214337.93 |
| 2024-09 | 513987.88 | 195386.30 | 20531.01 | 0.00 | 0.00 | 64125.08 | 233945.49 |
| 2024-11 | 754105.82 | 234203.18 | 35835.90 | 0.00 | 0.00 | 98226.71 | 385840.03 |
| 2025-11 | 607438.57 | 133907.09 | 36456.75 | 0.00 | 0.00 | 76849.30 | 360225.43 |
| 2025-12 | 17656.15 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 17656.15 |
| 2025-02 | 943076.33 | 316846.58 | 53285.37 | 0.00 | 0.00 | 129001.19 | 443943.19 |
| 2025-04 | 1604221.94 | 379863.84 | 98844.20 | 0.00 | 0.00 | 239628.96 | 885884.94 |
| 2023-02 | 494485.54 | 201539.26 | 10531.53 | 33221.07 | 18590.45 | 61872.23 | 168731.00 |
| 2023-03 | 539469.04 | 218360.93 | 16410.38 | 47851.69 | 29821.08 | 31244.28 | 195780.68 |
| 2023-04 | 647524.25 | 251253.48 | 40377.61 | 43549.32 | 40377.61 | 47330.87 | 224635.36 |
| 2023-10 | 636253.32 | 213173.41 | 51112.42 | 0.00 | 0.00 | 33221.07 | 338746.42 |
| 2024-01 | 434139.51 | 130577.17 | 13149.01 | 0.00 | 0.00 | 54429.81 | 235983.52 |
| 2024-06 | 496575.31 | 216889.72 | 20424.75 | 0.00 | 0.00 | 62668.06 | 196592.78 |
| 2024-10 | 595333.12 | 212787.04 | 14049.56 | 0.00 | 0.00 | 61379.29 | 307117.23 |
| 2024-12 | 859382.51 | 202918.36 | 50817.74 | 0.00 | 0.00 | 142182.36 | 463464.05 |
| 2025-10 | 1972871.34 | 500842.86 | 138966.31 | 0.00 | 0.00 | 245569.90 | 1087492.27 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-12-10 23:40:23.334 UTC