Thread: [Solved] Pivot Table issue
View Single Post
 
Old 07-18-2014, 01:40 AM
officepowerups officepowerups is offline Windows 8 Office 2013
Novice
 
Join Date: Jul 2014
Posts: 2
officepowerups is on a distinguished road
Default

Try creating a single 'Status' column where you indicate complete, incomplete, not started, etc.

In your pivot table, use the Status column your column labels as well as the Values.

You'll wind up with the counts of the status in a column that corresponds to the statuses you're using. And double-clicking on the values will show the records you're looking to see.

HTH,
Charlie
Reply With Quote