[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-02 | 584977.92 | 224489.85 | 36799.34 | 43549.32 | 33221.07 | 40174.33 | 206744.01 |
| 2023-06 | 642273.99 | 222785.33 | 60424.03 | 0.00 | 0.00 | 35782.70 | 323281.93 |
| 2023-08 | 627901.86 | 208896.04 | 47534.15 | 0.00 | 0.00 | 36799.34 | 334672.33 |
| 2023-12 | 383348.87 | 162381.18 | 15890.90 | 0.00 | 0.00 | 52869.62 | 152207.17 |
| 2024-02 | 477815.13 | 156740.65 | 15086.77 | 0.00 | 0.00 | 66759.70 | 239228.01 |
| 2024-03 | 502752.91 | 197383.74 | 25070.63 | 0.00 | 0.00 | 70214.64 | 210083.90 |
| 2024-10 | 860504.74 | 204763.87 | 53842.48 | 0.00 | 0.00 | 147692.70 | 454205.69 |
| 2025-03 | 1468877.66 | 387074.23 | 128567.68 | 0.00 | 0.00 | 177297.30 | 775938.45 |
| 2023-07 | 733248.41 | 244553.98 | 64027.30 | 0.00 | 0.00 | 32115.41 | 392551.72 |
| 2024-04 | 477608.20 | 207794.68 | 20424.75 | 0.00 | 0.00 | 64306.10 | 185082.67 |
| 2024-08 | 599896.30 | 218807.69 | 16098.66 | 0.00 | 0.00 | 59892.04 | 305097.91 |
| 2025-06 | 1457599.47 | 381844.01 | 87959.78 | 0.00 | 0.00 | 182493.72 | 805301.96 |
| 2025-10 | 20631.30 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 20631.30 |
| 2023-01 | 539469.04 | 218360.93 | 16410.38 | 47851.69 | 29821.08 | 31244.28 | 195780.68 |
| 2023-03 | 676588.46 | 235192.13 | 54169.87 | 22486.26 | 18590.45 | 61465.67 | 284684.08 |
| 2023-04 | 594115.98 | 185502.67 | 46656.77 | 0.00 | 0.00 | 79357.02 | 282599.52 |
| 2023-05 | 603021.03 | 204182.38 | 42735.96 | 0.00 | 0.00 | 25187.15 | 330915.54 |
| 2023-10 | 513690.28 | 140959.01 | 44471.59 | 0.00 | 0.00 | 48707.48 | 279552.20 |
| 2023-11 | 440014.02 | 139960.50 | 10967.45 | 0.00 | 0.00 | 64803.14 | 224282.93 |
| 2024-01 | 361416.02 | 128004.90 | 13294.29 | 0.00 | 0.00 | 46597.04 | 173519.79 |
| 2024-05 | 522593.13 | 210171.37 | 20080.65 | 0.00 | 0.00 | 67183.50 | 225157.61 |
| 2024-09 | 747840.15 | 240329.57 | 32536.80 | 0.00 | 0.00 | 97739.13 | 377234.65 |
| 2025-01 | 1113327.39 | 332726.26 | 74703.29 | 0.00 | 0.00 | 135000.38 | 570897.46 |
| 2025-02 | 1472512.71 | 343842.62 | 89079.53 | 0.00 | 0.00 | 222986.87 | 816603.69 |
| 2025-07 | 1841189.51 | 465870.74 | 139625.00 | 0.00 | 0.00 | 214130.82 | 1021562.95 |
| 2025-09 | 754858.35 | 179350.42 | 45564.90 | 0.00 | 0.00 | 96663.38 | 433279.65 |
| 2025-08 | 1969455.39 | 480893.11 | 137438.64 | 0.00 | 0.00 | 245156.29 | 1105967.35 |
| 2022-09 | 259933.22 | 113320.94 | 7156.54 | 21469.62 | 14134.80 | 22689.54 | 81161.78 |
| 2022-10 | 501182.48 | 229235.00 | 26242.81 | 32725.25 | 33196.07 | 33920.17 | 145863.18 |
| 2022-11 | 489349.54 | 193722.64 | 24641.33 | 32903.53 | 25365.43 | 68265.65 | 144450.96 |
| 2022-12 | 549518.77 | 219252.33 | 14109.80 | 36799.34 | 26242.81 | 69549.59 | 183564.90 |
| 2023-09 | 582819.90 | 148533.93 | 52108.35 | 0.00 | 0.00 | 36066.03 | 346111.59 |
| 2024-06 | 488119.14 | 205998.92 | 19328.88 | 0.00 | 0.00 | 51359.75 | 211431.59 |
| 2024-07 | 503533.68 | 183543.86 | 20531.01 | 0.00 | 0.00 | 62124.20 | 237334.61 |
| 2024-11 | 967494.78 | 260305.90 | 54212.00 | 0.00 | 0.00 | 122022.10 | 530954.78 |
| 2024-12 | 1054804.79 | 352429.71 | 66013.45 | 0.00 | 0.00 | 140694.81 | 495666.82 |
| 2025-04 | 1459024.05 | 420466.86 | 98250.86 | 0.00 | 0.00 | 183115.61 | 757190.72 |
| 2025-05 | 1515369.32 | 402316.27 | 84460.88 | 0.00 | 0.00 | 195922.52 | 832669.65 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-10-12 15:56:51.575 UTC