View Single Post
 
Old 02-02-2015, 07:02 AM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default 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.
Reply With Quote