BlueRhinos
Board Regular
- Joined
- Aug 31, 2007
- Messages
- 83
I have a pivot table a column header containing 3 values to indicate if someone has completed an assignment. Specifally, the values are (1) complete (2) in progress (3) not started. The row variable is a specific line of business groupsand provides completion counts. So, the table tells me that line of business A has 20 people, and 15 have completed the task, 3 are in progress, and 2 have not started. When i refresh the pivot table after updating the raw data, the table is returning a 4th value as a column header...namely Blank. there are no blank values in the raw data nor does the table have have any counts for that column. Any ideas why it's there and how I can fix?