I'm sure there's a better way than this but I make copy the pivot table and
paste it on another tab. Then I copy the 2nd one again and paste it as a
value (and I just paste it right on top of the one I just copied). Then you
can turn on the filters and do just about anything you want with it. A
couple of tricks, though. Anything you want to "bulk" format (like
highlighting all the totals, etc) should be done before you paste as a value.
It's certainly not impossible after, it just takes a little more work.

"Dan" wrote:

Hello everyone,

Is there any way to select fields within a pivot table that contain data, as
you can do with a filtered column within a spreadsheet? For example, only
show entries within a pivot table field that contain a particular word.

Thanks very much,

Dan