[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 | 498816.36 | 129484.35 | 42140.93 | 0.00 | 0.00 | 40549.91 | 286641.17 |
| 2023-06 | 527253.67 | 140543.49 | 35616.02 | 0.00 | 0.00 | 60674.62 | 290419.54 |
| 2023-11 | 423468.10 | 182286.19 | 12166.90 | 0.00 | 0.00 | 63925.53 | 165089.48 |
| 2023-12 | 525835.72 | 222275.90 | 21473.41 | 0.00 | 0.00 | 67301.72 | 214784.69 |
| 2024-02 | 487365.55 | 204352.65 | 11943.94 | 0.00 | 0.00 | 49171.93 | 221897.03 |
| 2024-05 | 886668.84 | 252872.32 | 39939.91 | 0.00 | 0.00 | 131081.06 | 462775.55 |
| 2024-07 | 1035592.29 | 331006.14 | 63453.15 | 0.00 | 0.00 | 132148.71 | 508984.29 |
| 2025-05 | 96572.35 | 11504.79 | 8481.83 | 0.00 | 0.00 | 11497.20 | 65088.53 |
| 2025-03 | 1859899.40 | 431894.55 | 128829.55 | 0.00 | 0.00 | 221379.93 | 1077795.37 |
| 2022-06 | 475652.79 | 212006.77 | 21965.44 | 40759.17 | 15533.00 | 50934.14 | 134454.27 |
| 2022-07 | 483711.47 | 170211.97 | 24844.61 | 25746.99 | 36075.24 | 59132.32 | 167700.34 |
| 2022-08 | 542362.23 | 235884.74 | 11929.73 | 36799.34 | 15012.18 | 62571.33 | 180164.91 |
| 2022-10 | 751949.67 | 284221.27 | 36278.52 | 52104.06 | 41254.99 | 50909.14 | 287181.69 |
| 2023-04 | 666182.17 | 202681.14 | 65222.22 | 0.00 | 0.00 | 42900.22 | 355378.59 |
| 2024-01 | 494572.27 | 195151.11 | 28248.58 | 0.00 | 0.00 | 57881.92 | 213290.66 |
| 2024-04 | 554799.35 | 202635.30 | 5686.50 | 0.00 | 0.00 | 57193.72 | 289283.83 |
| 2025-01 | 1470916.64 | 392275.52 | 84488.59 | 0.00 | 0.00 | 190168.96 | 803983.57 |
| 2022-09 | 532152.97 | 199948.76 | 29846.08 | 46771.03 | 33221.07 | 26966.91 | 195399.12 |
| 2022-11 | 570007.97 | 212780.87 | 46835.05 | 3578.27 | 0.00 | 71298.10 | 235515.68 |
| 2022-12 | 618111.25 | 179262.53 | 60944.85 | 0.00 | 0.00 | 50755.86 | 327148.01 |
| 2023-02 | 611384.99 | 209617.17 | 60627.31 | 0.00 | 0.00 | 28626.16 | 312514.35 |
| 2023-03 | 706078.22 | 216245.12 | 53292.49 | 0.00 | 0.00 | 32814.51 | 403726.10 |
| 2023-07 | 375397.51 | 128704.12 | 15126.05 | 0.00 | 0.00 | 51904.90 | 179662.44 |
| 2023-09 | 326633.75 | 102040.82 | 9231.04 | 0.00 | 0.00 | 48077.28 | 167284.61 |
| 2023-10 | 581654.83 | 202230.71 | 23858.10 | 0.00 | 0.00 | 75954.76 | 279611.26 |
| 2024-03 | 562772.72 | 204157.69 | 30160.18 | 0.00 | 0.00 | 70631.68 | 257823.17 |
| 2024-10 | 1731787.77 | 383048.53 | 121553.74 | 0.00 | 0.00 | 226550.49 | 1000635.01 |
| 2025-04 | 1975037.81 | 486589.48 | 136349.84 | 0.00 | 0.00 | 253021.22 | 1099077.27 |
| 2025-06 | 2643.61 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2643.61 |
| 2022-05 | 458376.01 | 206074.64 | 21965.44 | 32026.15 | 39475.23 | 37498.44 | 121336.11 |
| 2023-01 | 637881.08 | 232788.27 | 28422.88 | 0.00 | 0.00 | 36100.24 | 340569.69 |
| 2023-08 | 421798.56 | 192701.37 | 18485.04 | 0.00 | 0.00 | 53326.99 | 157285.16 |
| 2024-06 | 822079.35 | 182891.71 | 60393.06 | 0.00 | 0.00 | 121785.60 | 457008.98 |
| 2024-08 | 1080449.58 | 343648.32 | 47762.72 | 0.00 | 0.00 | 155724.59 | 533313.95 |
| 2024-09 | 1196981.11 | 335362.46 | 93480.18 | 0.00 | 0.00 | 167123.73 | 601014.74 |
| 2024-11 | 1303838.55 | 371864.22 | 110177.82 | 0.00 | 0.00 | 158474.26 | 663322.25 |
| 2024-12 | 1568507.43 | 447273.13 | 91202.98 | 0.00 | 0.00 | 203475.33 | 826555.99 |
| 2025-02 | 1493483.95 | 413470.10 | 104092.82 | 0.00 | 0.00 | 168816.31 | 807104.72 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-06-01 19:54:55.722 UTC