ALV and totals by currency and great total in USD
I am working on a Detail/Summary Report and I'm having trouble in displaying the last total. My program works using ALV grid display. I'm getting fine the Total Amount per Currency. But I would like to display a final general total all in USD. For example:
ITEM CURRENCY AMMOUNT
1 EUR 10
2 EUR 5
3 ARS 20
4 ARS 10
5 ARS 20
6 USD 20
GREAT TOTAL IN USD ???
Great USD total will be get by translating EUR and ARS' amounts to USD (item number 6 is ok). Any idea? I think that I can't do this but I would like to check with your expertise.
Thanks in advance and Kind regards,