How to display Currency Code along with the amount values in pivot table

[Siraj.Samsudeen]

I have an Invoice table with the following columns: Date, Client Name, Currency Code, Amount, Amount in USD. The real table has a lot of columns, but for our purposes, these columns will do.

I want to show the customers along with their Total Amount in Original Currency and USD. For USD amount, I can format the column to show $ symbol. For for the other field, ideally, I want to show the currency code along with the value. I thought of doing a calculated column combining the currency code, but that is ugly and will also mess up sorting and conditional formatting with data bars.

Is there a way to display the currency code column just before these 2 value field so it looks like this:

Customer Name, Currency Code, Total Amount, Total Amount in USD.

I remember in 2003 Excel version Pivot table, there was a hack that I could use to display something like this, but I forgot it and anyway, now with PowerPivot, I don't know how to get it to work. Any ideas?

 

[gand3rson]

I am not sure how u could this, maybe with a separate table listing all unique customers and their currency code, relating that table by customer to the invoice table. I am assuming a customer can only have one customer code?