[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2026-04 | 1815831.69 | 446169.16 | 123949.78 | 0.00 | 0.00 | 238717.02 | 1006995.73 |
| 2023-06 | 516430.71 | 222042.48 | 32496.97 | 40759.17 | 14630.62 | 65068.94 | 141432.53 |
| 2023-08 | 522627.10 | 217611.83 | 11929.73 | 47152.59 | 7156.54 | 51836.52 | 186939.89 |
| 2024-04 | 656323.03 | 195780.45 | 57388.01 | 0.00 | 0.00 | 30534.68 | 372619.89 |
| 2024-09 | 370603.05 | 113625.35 | 7181.94 | 0.00 | 0.00 | 56668.23 | 193127.53 |
| 2024-11 | 423632.57 | 172139.81 | 14105.86 | 0.00 | 0.00 | 56708.00 | 180678.90 |
| 2025-03 | 550984.29 | 201933.27 | 20414.31 | 0.00 | 0.00 | 71172.07 | 257464.64 |
| 2025-04 | 611473.65 | 222282.70 | 10329.43 | 0.00 | 0.00 | 65829.78 | 313031.74 |
| 2025-05 | 857689.91 | 227812.15 | 46117.33 | 0.00 | 0.00 | 127683.98 | 456076.45 |
| 2023-07 | 459947.52 | 173611.96 | 10734.81 | 18590.45 | 36977.62 | 55732.33 | 164300.35 |
| 2023-11 | 579643.37 | 216155.86 | 46135.95 | 0.00 | 0.00 | 68101.39 | 249250.17 |
| 2023-12 | 613655.60 | 183361.62 | 57366.58 | 0.00 | 0.00 | 44298.42 | 328628.98 |
| 2024-02 | 675736.08 | 228054.34 | 67783.85 | 0.00 | 0.00 | 31797.87 | 348100.02 |
| 2024-03 | 651005.97 | 201589.50 | 50934.14 | 0.00 | 0.00 | 39996.05 | 358486.28 |
| 2024-08 | 393702.79 | 174370.36 | 17569.59 | 0.00 | 0.00 | 43798.57 | 157964.27 |
| 2024-10 | 573569.43 | 215830.68 | 26039.66 | 0.00 | 0.00 | 73400.22 | 258298.87 |
| 2025-01 | 487421.14 | 192004.66 | 24782.47 | 0.00 | 0.00 | 64113.46 | 206520.55 |
| 2026-03 | 1839448.66 | 427300.13 | 139783.22 | 0.00 | 0.00 | 212582.20 | 1059783.11 |
| 2025-08 | 1096248.31 | 346888.42 | 56834.08 | 0.00 | 0.00 | 142882.93 | 549642.88 |
| 2025-11 | 1349723.38 | 391798.89 | 107986.85 | 0.00 | 0.00 | 163894.95 | 686042.69 |
| 2023-04 | 43421.04 | 20909.78 | 3578.27 | 0.00 | 3399.99 | 699.10 | 14833.90 |
| 2023-05 | 469823.94 | 207130.30 | 21965.44 | 39182.69 | 43930.88 | 36799.34 | 120815.29 |
| 2023-09 | 577228.53 | 225353.21 | 33424.35 | 39996.05 | 43955.88 | 31244.28 | 203254.76 |
| 2023-10 | 731179.15 | 263654.03 | 36977.62 | 52104.06 | 30520.18 | 60563.29 | 287359.97 |
| 2024-05 | 497962.89 | 126866.08 | 42907.11 | 0.00 | 0.00 | 45657.94 | 282531.76 |
| 2024-06 | 516432.77 | 146665.00 | 35244.09 | 0.00 | 0.00 | 62852.30 | 271671.38 |
| 2026-05 | 45694.72 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 45694.72 |
| 2025-12 | 1538140.76 | 431388.66 | 89630.09 | 0.00 | 0.00 | 201587.24 | 815534.77 |
| 2026-01 | 1507408.04 | 412908.98 | 89054.16 | 0.00 | 0.00 | 182695.90 | 822749.00 |
| 2026-02 | 1519921.98 | 401619.82 | 100622.48 | 0.00 | 0.00 | 187749.96 | 829929.72 |
| 2024-01 | 638256.39 | 231568.35 | 35579.42 | 0.00 | 0.00 | 35401.14 | 335707.48 |
| 2024-07 | 373464.81 | 131908.03 | 13575.83 | 0.00 | 0.00 | 57727.74 | 170253.21 |
| 2024-12 | 535898.91 | 227666.41 | 24917.20 | 0.00 | 0.00 | 69900.60 | 213414.70 |
| 2025-02 | 491008.10 | 200933.56 | 17591.61 | 0.00 | 0.00 | 44089.05 | 228393.88 |
| 2025-06 | 850944.47 | 198887.80 | 57794.61 | 0.00 | 0.00 | 122448.61 | 471813.45 |
| 2025-07 | 1035667.48 | 338257.37 | 58827.35 | 0.00 | 0.00 | 137242.28 | 501340.48 |
| 2025-09 | 1283270.61 | 336379.09 | 88819.86 | 0.00 | 0.00 | 194425.13 | 663646.53 |
| 2025-10 | 1657255.05 | 379528.13 | 126143.45 | 0.00 | 0.00 | 212448.21 | 939135.26 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2026-05-28 22:49:19.000 UTC