[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-04 | 28408.86 | 13753.24 | 3578.27 | 0.00 | 3399.99 | 0.00 | 7677.36 |
| 2024-06 | 518548.53 | 142800.76 | 37687.44 | 0.00 | 0.00 | 61851.86 | 276208.47 |
| 2024-07 | 377480.40 | 141047.71 | 13575.83 | 0.00 | 0.00 | 52293.64 | 170563.22 |
| 2025-06 | 834406.78 | 190236.37 | 55372.87 | 0.00 | 0.00 | 122068.77 | 466728.77 |
| 2025-11 | 1332523.68 | 387086.89 | 107128.25 | 0.00 | 0.00 | 156493.48 | 681815.06 |
| 2025-12 | 1537675.33 | 431577.12 | 92696.12 | 0.00 | 0.00 | 205683.89 | 807718.20 |
| 2026-02 | 1488306.01 | 405872.05 | 100678.53 | 0.00 | 0.00 | 173681.87 | 808073.56 |
| 2023-05 | 473605.49 | 203056.21 | 21965.44 | 39182.69 | 43930.88 | 37498.44 | 127971.83 |
| 2023-09 | 555758.91 | 221393.38 | 33424.35 | 43574.32 | 40377.61 | 27666.01 | 189323.24 |
| 2023-11 | 589094.24 | 223312.40 | 49714.22 | 0.00 | 0.00 | 71298.10 | 244769.52 |
| 2024-01 | 631303.13 | 231568.35 | 35579.42 | 0.00 | 0.00 | 35401.14 | 328754.22 |
| 2024-03 | 668198.22 | 219099.29 | 43955.88 | 0.00 | 0.00 | 36621.06 | 368521.99 |
| 2024-12 | 537349.24 | 226789.04 | 24917.20 | 0.00 | 0.00 | 71684.03 | 213958.97 |
| 2025-05 | 877828.70 | 239908.60 | 43736.10 | 0.00 | 0.00 | 126920.21 | 467263.79 |
| 2026-01 | 1535892.02 | 415106.31 | 90786.44 | 0.00 | 0.00 | 188316.67 | 841682.60 |
| 2023-06 | 491878.64 | 218960.03 | 28918.70 | 37180.90 | 11052.35 | 57912.40 | 137854.26 |
| 2023-07 | 481417.14 | 180768.50 | 14313.08 | 22168.72 | 40555.89 | 62888.87 | 160722.08 |
| 2023-12 | 621511.24 | 186939.89 | 57366.58 | 0.00 | 0.00 | 47876.69 | 329328.08 |
| 2024-04 | 661779.18 | 197177.16 | 65873.12 | 0.00 | 0.00 | 33126.68 | 365602.22 |
| 2024-09 | 369213.87 | 111576.25 | 7181.94 | 0.00 | 0.00 | 56668.23 | 193787.45 |
| 2024-10 | 558772.99 | 205924.82 | 26039.66 | 0.00 | 0.00 | 71218.66 | 255589.85 |
| 2024-11 | 430959.08 | 182528.79 | 14105.86 | 0.00 | 0.00 | 57106.13 | 177218.30 |
| 2025-01 | 488860.17 | 190217.35 | 24782.47 | 0.00 | 0.00 | 60931.46 | 212928.89 |
| 2025-03 | 555026.08 | 201823.13 | 23858.10 | 0.00 | 0.00 | 71955.06 | 257389.79 |
| 2025-09 | 1260423.57 | 336824.81 | 89930.07 | 0.00 | 0.00 | 189686.87 | 643981.82 |
| 2026-03 | 1841490.91 | 420724.41 | 136772.61 | 0.00 | 0.00 | 217468.83 | 1066525.06 |
| 2026-05 | 47491.55 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 47491.55 |
| 2025-08 | 1102024.46 | 348118.02 | 54530.69 | 0.00 | 0.00 | 146906.38 | 552469.37 |
| 2025-10 | 1668804.90 | 376797.97 | 123244.72 | 0.00 | 0.00 | 213244.30 | 955517.91 |
| 2023-08 | 523008.66 | 214415.12 | 11929.73 | 43574.32 | 7156.54 | 51836.52 | 194096.43 |
| 2023-10 | 738538.97 | 267232.30 | 33399.35 | 52104.06 | 34098.45 | 57366.58 | 294338.23 |
| 2024-02 | 654444.74 | 206966.28 | 64205.58 | 0.00 | 0.00 | 31797.87 | 351475.01 |
| 2024-05 | 495364.01 | 123772.20 | 42535.18 | 0.00 | 0.00 | 46440.93 | 282615.70 |
| 2024-08 | 404057.98 | 174370.36 | 17569.59 | 0.00 | 0.00 | 50233.11 | 161884.92 |
| 2025-02 | 482350.79 | 201043.70 | 14147.82 | 0.00 | 0.00 | 46488.06 | 220671.21 |
| 2025-04 | 581076.54 | 210763.40 | 9754.45 | 0.00 | 0.00 | 60247.05 | 300311.64 |
| 2025-07 | 1041239.42 | 339805.62 | 63884.10 | 0.00 | 0.00 | 139072.89 | 498476.81 |
| 2026-04 | 1872563.46 | 462630.39 | 127377.74 | 0.00 | 0.00 | 250396.98 | 1032158.35 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-05-29 17:20:15.200 UTC