Extracting characters from a pivot table field

[Ryckiej]

I have a pivot table that draws it's information from an external cube. One of the fields in the pivot table contains an agency name and number. The agency number can be anything from 1 to 4 digits. It looks like this: INSURANCE AGENCY (1234) Is there a way to extract the number from the field and create a new field? I can easily do this outside of the pivot table, but can't figure out how to tie it to the pivot table. The best solution would be to create a new field using MDX Calculated Measure, but not sure how to write it.

Any help would be greatly appreciated.