I have two files,in file-1 I have currencies like CAD,EUR,GBP,KRW,MYR,USD and
in file-2 I have BRL,CAD,EUR,GBP,HUF,PLN,RON,TRY,USD.
Currencies which are extra in file-2 are in USD in file-1,now how can I convert those local currencies in file-2 into USD and keep remaining currencies same so that I can get an expression Sum(Net) where Net is a field in file-2
That's a littel vague to work from. I suggest that you prepare a sample of file1 and file2, and give specific examples of the results you would like to achieve.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Attached a sample file.Here,sheet-1 is file-1 in which India is shown in USD but the corresponding sale for same site is shown in INR in sheet-2,but in output in pivot table I need to convert INR to USD and show the corresponding value,similarly for Brazil.
