[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
39 items
OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
---|---|---|---|---|---|---|---|
2024-04 | 33663.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 33663.50 |
2021-03 | 141393.51 | 53431.75 | 3578.27 | 14313.08 | 6978.26 | 18412.17 | 44679.98 |
2021-09 | 652050.41 | 207685.65 | 47013.33 | 37295.16 | 22168.72 | 64662.38 | 273225.17 |
2021-07 | 539997.63 | 213156.18 | 12628.83 | 62660.59 | 15012.18 | 34123.45 | 202416.40 |
2021-10 | 634448.32 | 233373.11 | 50438.32 | 0.00 | 0.00 | 89367.73 | 261269.16 |
2022-05 | 497995.61 | 143598.65 | 26104.41 | 0.00 | 0.00 | 64085.95 | 264206.60 |
2022-01 | 730527.01 | 248003.97 | 60830.59 | 0.00 | 0.00 | 35871.96 | 385820.49 |
2022-07 | 401606.57 | 171294.62 | 17437.13 | 0.00 | 0.00 | 45060.80 | 167814.02 |
2023-03 | 692061.09 | 239617.22 | 16347.73 | 0.00 | 0.00 | 80088.94 | 356007.20 |
2022-09 | 525295.67 | 207917.51 | 21184.37 | 0.00 | 0.00 | 64178.23 | 232015.56 |
2023-12 | 1525786.80 | 411837.76 | 82469.16 | 0.00 | 0.00 | 181846.20 | 849633.68 |
2023-01 | 544281.04 | 204542.08 | 23495.56 | 0.00 | 0.00 | 60703.31 | 255540.09 |
2023-02 | 506508.09 | 188408.90 | 15315.67 | 0.00 | 0.00 | 55885.84 | 246897.68 |
2023-04 | 826530.72 | 220473.94 | 44384.32 | 0.00 | 0.00 | 129492.12 | 432180.34 |
2023-05 | 920537.56 | 208837.54 | 66494.79 | 0.00 | 0.00 | 139321.69 | 505883.54 |
2023-08 | 1430891.09 | 362424.95 | 86287.39 | 0.00 | 0.00 | 216817.60 | 765361.15 |
2024-01 | 1772014.35 | 445128.45 | 127436.27 | 0.00 | 0.00 | 217037.17 | 982412.46 |
2021-11 | 579378.87 | 180100.89 | 46110.95 | 0.00 | 0.00 | 22307.98 | 330859.05 |
2021-12 | 646939.41 | 227915.08 | 42532.68 | 0.00 | 0.00 | 39182.69 | 337308.96 |
2022-03 | 632651.07 | 172266.27 | 63653.44 | 0.00 | 0.00 | 31837.44 | 364893.92 |
2022-08 | 434760.12 | 131778.81 | 14086.33 | 0.00 | 0.00 | 66411.42 | 222483.56 |
2022-12 | 495806.30 | 197932.15 | 22578.59 | 0.00 | 0.00 | 62725.33 | 212570.23 |
2023-09 | 1532310.04 | 338229.41 | 132945.68 | 0.00 | 0.00 | 192945.26 | 868189.69 |
2023-06 | 1020593.39 | 330555.92 | 57764.51 | 0.00 | 0.00 | 127343.94 | 504929.02 |
2023-07 | 1111155.27 | 358555.13 | 68936.42 | 0.00 | 0.00 | 136834.58 | 546829.14 |
2023-10 | 1467129.63 | 456068.06 | 100621.04 | 0.00 | 0.00 | 183193.59 | 727246.94 |
2021-04 | 491051.26 | 252349.85 | 21965.44 | 28447.88 | 40352.61 | 31219.28 | 116716.20 |
2021-05 | 523626.27 | 187761.02 | 32496.97 | 40759.17 | 21787.16 | 66867.45 | 173954.50 |
2021-06 | 465241.53 | 190918.47 | 10734.81 | 18590.45 | 29821.08 | 63791.25 | 151385.47 |
2021-08 | 620053.75 | 253954.37 | 40377.61 | 35718.68 | 44451.70 | 30545.18 | 215006.21 |
2022-02 | 593836.18 | 199745.48 | 47152.59 | 0.00 | 0.00 | 35921.96 | 311016.15 |
2022-04 | 483413.68 | 122073.01 | 39611.09 | 0.00 | 0.00 | 46728.92 | 275000.66 |
2022-06 | 348664.14 | 134712.59 | 14974.40 | 0.00 | 0.00 | 50081.87 | 148895.28 |
2022-10 | 480585.38 | 193248.73 | 22479.36 | 0.00 | 0.00 | 70845.27 | 194012.02 |
2022-11 | 499323.49 | 219509.59 | 16698.48 | 0.00 | 0.00 | 56429.62 | 206685.80 |
2023-11 | 1441675.85 | 393925.76 | 84866.85 | 0.00 | 0.00 | 189860.67 | 773022.57 |
2024-02 | 1758706.31 | 426050.70 | 141582.24 | 0.00 | 0.00 | 192966.98 | 998106.39 |
2024-03 | 1356186.98 | 324604.65 | 82901.88 | 0.00 | 0.00 | 193353.50 | 755326.95 |
_SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2024-04-20 11:08:14.344 UTC