|
|
#2
07-18-2014, 01:40 AM
|
|||
|
|||
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 
|
| Tags |
| pivot chart, pivot table |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Table Issue | Grovesy | Excel | 0 | 10-28-2012 09:08 PM |
| Pivot Table | uhlersa | Excel | 0 | 10-15-2012 12:01 PM |
 pivot table
|
aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
|
Help with a pivot table please!
|
natsha | Excel | 1 | 02-16-2012 12:41 PM |
|
Pivot Table
|
Karen615 | Excel | 5 | 08-03-2011 10:46 AM |
Windows 8 
Office 2013
Threaded Mode