Hi all - I have an worksheet style database in Excel that contains information on several firms over several periods. Each measure is in the firm's native currency (USD, CAD) and I also have a column with the converted currency (CAD). In my Pivot Tables, I would like the ability to sum to one...