Bex: currency conv at prev date

Hello BE Experts,

Wondering if there is a way to do the currency conversion in the Bex report for a previous date currency rates.

eg: I want to run the report for the past 6 months of sales for the europe in USD. each month is displayed in the one column. For each month can we get the currency conv rates of that month rather than the current month ?

Any suggestions appreciated.

Thanks,

BWer