How do you copy a field to use as a filter and as a row?

[squeakums]

I want to display names on a row in a pivot table but also I want the option to filter because I'm using a macro with it. How can you use the same field twice? I read that you can use a calculated field but when I create it, and try to use it I get an error message "the field you are using cannot be placed in that area".