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
|