Dear all,
I have pivot table which tracks all billing transactions. I work with USD, EUR, INR etc..
In the pivot chart, I would like to have all currency converted to USD. I struggled with Pivot item and Pivot field. But reference to conversion factor outside the pivot table was not allowed.
Attached workbook has three worksheet. In the resource sheet, currency conversion factor is listed. Custom formula in the pivot report has to check which currency it is and to do the conversion based on the reference table.
Could you please guide me to solve this issue.
Thanks,
Suresh
Bookmarks