I have a Pivot Table with 6 columns. I want to be able to have the option to filer on the 6 columns in the pivot table....similar to an autofilter option in a spreadsheet. Is there a way to do it? When I highlight the column heading in the pivot table is does not give me the option for auto filter for each column.

I believe you can only filter on those fields that you have set as Row labels. If there is no little autofilter doohickey at the top, you can't filter.

However, if you right-click those heading that don't, there are many options available to you.