Sorting in Pivot table
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.
|