PDA

View Full Version : Solved: Pivot Table problem



majaro
02-04-2008, 07:13 AM
I'm trying to do a pivot table based on the attached workbook. When I drag the first item to the "Drop Row Fields Here" section, about 5 rows down there is a row in my data that looks like some sort of Column Heading but after checking the data there is not one of these in my data. Anyone have any idea what is going on here? Thanks

Bob Phillips
02-04-2008, 07:35 AM
Can you give a bit more detail, as I couldn't see anything untoward? What fields did you include, what is the text?

majaro
02-04-2008, 07:52 AM
Here is what I mean. Look at rows 7 of the attached Pivot Table on Sheet1. If you drag Practice Site over it creates the same thing for that group.

Bob Phillips
02-04-2008, 07:59 AM
That is because your table has two heading lines, and the pivot is reading the second as a data row.

majaro
02-04-2008, 07:59 AM
Thanks Sid.