I need to show cumulated values of previous year(PYTD) converted with the exchange rate of the current year (e.g. Jan 06 value converted with Jan 07, Feb 06 with Feb 07 etc.).
I can't upload the converted value, because the rate (monthly average) is fixed at the end of the month.
Is ther any solution to do this at query runtime?
I tried RRC1 etc., but got nowhere yet,