My pivot table needs to support multiple languages. I normally do this using a lookup technique but I get the message "cannot enter a formula for an item or field name in a pivot table report".

Is there a way to soft code Column Names in a Powerpivot table?

Any pointers would be appreciated.