[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount
38 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2023-01 | 506191.72 | 222538.30 | 28918.70 | 40759.17 | 18208.89 | 54334.13 | 141432.53 |
| 2023-03 | 521070.89 | 221749.94 | 11929.73 | 33221.07 | 15012.18 | 62571.33 | 176586.64 |
| 2024-04 | 326633.75 | 102040.82 | 9231.04 | 0.00 | 0.00 | 48077.28 | 167284.61 |
| 2024-05 | 581654.83 | 202230.71 | 23858.10 | 0.00 | 0.00 | 75954.76 | 279611.26 |
| 2025-02 | 957927.86 | 303307.38 | 59191.15 | 0.00 | 0.00 | 128859.35 | 466569.98 |
| 2025-05 | 1707253.07 | 376500.72 | 119507.51 | 0.00 | 0.00 | 220954.61 | 990290.23 |
| 2025-07 | 1542380.39 | 429130.34 | 91009.46 | 0.00 | 0.00 | 187227.86 | 835012.73 |
| 2025-09 | 1608750.53 | 446171.93 | 107133.96 | 0.00 | 0.00 | 185799.29 | 869645.35 |
| 2025-06 | 1318867.54 | 380318.49 | 111899.30 | 0.00 | 0.00 | 167224.58 | 659425.17 |
| 2022-12 | 473388.19 | 209652.91 | 21965.44 | 35604.42 | 40174.33 | 37498.44 | 128492.65 |
| 2025-10 | 1878317.51 | 435562.23 | 137963.23 | 0.00 | 0.00 | 208893.85 | 1095898.20 |
| 2024-01 | 546001.36 | 149740.44 | 40130.79 | 0.00 | 0.00 | 64033.42 | 292096.71 |
| 2023-06 | 583240.39 | 212056.77 | 46835.05 | 6978.26 | 0.00 | 71298.10 | 246072.21 |
| 2025-11 | 1949361.11 | 479544.88 | 132784.61 | 0.00 | 0.00 | 262597.06 | 1074434.56 |
| 2024-06 | 423468.10 | 182286.19 | 12166.90 | 0.00 | 0.00 | 63925.53 | 165089.48 |
| 2023-07 | 610979.71 | 186444.07 | 60944.85 | 0.00 | 0.00 | 50755.86 | 312834.93 |
| 2023-02 | 437461.26 | 156102.17 | 17891.35 | 22168.72 | 32700.25 | 55732.33 | 152866.44 |
| 2024-08 | 494572.27 | 195151.11 | 28248.58 | 0.00 | 0.00 | 57881.92 | 213290.66 |
| 2023-09 | 663692.33 | 224451.07 | 67783.85 | 0.00 | 0.00 | 35376.14 | 336081.27 |
| 2023-04 | 536252.06 | 206927.02 | 29846.08 | 50349.30 | 29642.80 | 23388.64 | 196098.22 |
| 2024-10 | 566264.15 | 209309.01 | 28088.76 | 0.00 | 0.00 | 69233.11 | 259633.27 |
| 2023-10 | 673556.25 | 205688.59 | 46135.95 | 0.00 | 0.00 | 26064.53 | 395667.18 |
| 2023-05 | 745352.97 | 280846.28 | 36278.52 | 48704.07 | 44833.26 | 54487.41 | 280203.43 |
| 2025-01 | 847138.65 | 189999.61 | 56704.91 | 0.00 | 0.00 | 121837.36 | 478596.77 |
| 2023-11 | 676763.70 | 209659.40 | 65222.22 | 0.00 | 0.00 | 42900.22 | 358981.86 |
| 2023-08 | 644135.24 | 232584.99 | 28422.88 | 0.00 | 0.00 | 36100.24 | 347027.13 |
| 2025-08 | 1480905.18 | 396441.11 | 86590.50 | 0.00 | 0.00 | 203995.31 | 793878.26 |
| 2023-12 | 500365.03 | 130989.73 | 42140.93 | 0.00 | 0.00 | 42599.01 | 284635.36 |
| 2024-02 | 336867.26 | 111023.53 | 10611.28 | 0.00 | 0.00 | 46497.00 | 168735.45 |
| 2024-11 | 553120.04 | 193993.78 | 7437.48 | 0.00 | 0.00 | 55627.74 | 296061.04 |
| 2024-03 | 421798.56 | 192701.37 | 18485.04 | 0.00 | 0.00 | 53326.99 | 157285.16 |
| 2024-12 | 885221.49 | 254348.14 | 43320.11 | 0.00 | 0.00 | 133456.01 | 454097.23 |
| 2024-07 | 525835.72 | 222275.90 | 21473.41 | 0.00 | 0.00 | 67301.72 | 214784.69 |
| 2025-03 | 1074568.43 | 349377.37 | 47763.90 | 0.00 | 0.00 | 150841.37 | 526585.79 |
| 2024-09 | 509445.56 | 211545.03 | 14015.36 | 0.00 | 0.00 | 52136.48 | 231748.69 |
| 2025-04 | 1199034.16 | 339075.16 | 94114.42 | 0.00 | 0.00 | 169509.28 | 596335.30 |
| 2025-12 | 50840.63 | 221.73 | 472.15 | 0.00 | 0.00 | 51.46 | 50095.29 |
| _SUM | 29358677.89 | 9051988.22 | 1806517.50 | 237785.01 | 180571.71 | 3388349.72 | 14693465.73 |
Generated 2025-12-31 09:19:54.821 UTC