Display currency symbol in a report
We have Pipeline reports that displays Forecast Amount(Local Currency). The Forecast Amount(Local Currency) is coming User level currency setup.
Is it possible to show the report currency (=user currency) in the Pivot Table? like below;
Product Type Forecast Amount(Local Currency)
AA USD 2000.00
BB JPY 150000.00
We do not want the currency symbol in the column (because of excel export), but somewhere the currency code should be written...
Thanks,
Babu