[ROOT] dt FactResellerSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
37 items
OrderDate.YearMonth()Id | _SUM | AUD | CAD | EUR | GBP | USD |
---|---|---|---|---|---|---|
2023-04 | 4212971.11 | 134280.93 | 566980.25 | 345105.45 | 213490.69 | 2953113.79 |
2023-11 | 2738653.08 | 200598.08 | 464632.31 | 135285.30 | 310841.69 | 1627295.70 |
2022-06 | 1802154.64 | 0.00 | 396580.74 | 18715.31 | 63332.87 | 1323525.72 |
2023-05 | 4047573.76 | 266778.71 | 676757.35 | 125723.49 | 496251.53 | 2482062.68 |
2021-03 | 489328.56 | 0.00 | 115360.89 | 0.00 | 0.00 | 373967.67 |
2022-08 | 2185213.50 | 0.00 | 489254.96 | 0.00 | 165996.35 | 1529962.19 |
2021-04 | 1538408.37 | 0.00 | 316981.09 | 0.00 | 0.00 | 1221427.28 |
2021-08 | 1702944.74 | 0.00 | 258662.93 | 0.00 | 0.00 | 1444281.81 |
2022-09 | 1317541.93 | 0.00 | 260489.70 | 4802.34 | 36790.87 | 1015459.02 |
2021-05 | 1165897.12 | 0.00 | 205640.89 | 0.00 | 0.00 | 960256.23 |
2022-11 | 1563955.26 | 0.00 | 394256.94 | 0.00 | 115841.41 | 1053856.91 |
2023-01 | 2880753.01 | 0.00 | 467681.21 | 10323.46 | 112217.59 | 2290530.75 |
2022-02 | 1001804.06 | 0.00 | 177981.61 | 0.00 | 0.00 | 823822.45 |
2023-02 | 1987873.21 | 0.00 | 443495.39 | 0.00 | 130528.71 | 1413849.11 |
2023-03 | 2665650.23 | 49824.66 | 501046.16 | 203606.58 | 152484.43 | 1758688.40 |
2022-05 | 2885359.49 | 0.00 | 564052.82 | 0.00 | 208360.57 | 2112946.10 |
2021-10 | 1900789.10 | 0.00 | 276631.20 | 0.00 | 0.00 | 1624157.90 |
2022-07 | 3053816.72 | 0.00 | 510381.42 | 8628.91 | 140645.39 | 2394161.00 |
2022-03 | 2393689.74 | 0.00 | 638115.26 | 42438.45 | 80686.69 | 1632449.34 |
2023-10 | 2699299.98 | 76501.59 | 322799.05 | 191559.42 | 151047.78 | 1957392.14 |
2023-06 | 2282115.52 | 55341.44 | 402367.58 | 203759.61 | 116094.07 | 1504552.82 |
2024-01 | 3314600.32 | 116068.35 | 395411.87 | 257717.15 | 198648.02 | 2346754.93 |
2023-08 | 3510947.92 | 216979.93 | 712116.18 | 161191.77 | 418460.98 | 2002199.06 |
2023-09 | 1662547.07 | 63379.58 | 236714.33 | 123518.17 | 80574.29 | 1158360.70 |
2021-06 | 844721.13 | 0.00 | 234907.26 | 0.00 | 0.00 | 609813.87 |
2021-07 | 2324136.02 | 0.00 | 381806.55 | 0.00 | 0.00 | 1942329.47 |
2021-09 | 713116.80 | 0.00 | 163779.88 | 0.00 | 0.00 | 549336.92 |
2021-11 | 1455280.58 | 0.00 | 335344.51 | 0.00 | 0.00 | 1119936.07 |
2021-12 | 882900.17 | 0.00 | 228067.80 | 0.00 | 0.00 | 654832.37 |
2022-01 | 2269116.74 | 0.00 | 384642.66 | 0.00 | 0.00 | 1884474.08 |
2022-04 | 3601191.54 | 0.00 | 658167.12 | 10514.54 | 182736.00 | 2749773.88 |
2022-10 | 2384846.62 | 0.00 | 353871.90 | 10679.41 | 121274.44 | 1899020.87 |
2022-12 | 1865278.70 | 0.00 | 438822.42 | 11804.22 | 48081.43 | 1366570.63 |
2023-07 | 3483160.34 | 124225.06 | 433419.93 | 285286.62 | 198629.81 | 2441598.92 |
2023-12 | 2206724.86 | 58814.46 | 385506.62 | 187417.99 | 110014.20 | 1464971.59 |
2024-02 | 3416234.17 | 231542.06 | 585196.93 | 136457.19 | 425979.08 | 2037058.91 |
_SUM | 80450596.11 | 1594334.85 | 14377925.71 | 2474535.38 | 4279008.89 | 57724791.28 |
Generated 2024-04-25 23:33:51.161 UTC