Pivot Table, duplicated data

PaulB · Apr 12th, 2002, 10:11 AM

I use pivot tables to gather sales data from Access via MSQuery and display for all sales staff. I keep getting redundant data in a field. i.e. I have a column for periods 1 to 12 and currently am at period 7. For some reason I am recently seeing each prd number duplicated when I select the field for this column as if I'm going to supress data. I can supress the duplicates but why am I getting them? Anyone help?
This also happens if I had data for a specific area in say the Area column, which now no longer exists in the data within Access, but the pivot table still seems to think that the heading is still there, albeit with blank data.

Chris Davison · Apr 13th, 2002, 08:32 AM

Hi Paul,

no replies so I'll stick my oar in

I seem to remember something similar posted a few weeks ago and the answer suggested (again in desperation) was to recreate the pivot from scratch on a new sheet.......

PaulB · Apr 15th, 2002, 06:29 AM

Chris,

Thanks very much for your reply. Yep, I think your right, it's the only way I can see to correct the problem, and as you'd expect, no duplicates in the new pivot table??
Anyone else explain why this happens?

PaulB

Paul B · Apr 15th, 2002, 07:59 AM

Thought I posted a question and forgot about it! Two Paul B’s on the board, mine with a space yours without. Paul B

Apr 13th, 2002, 08:32 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Hi Paul, no replies so I'll stick my oar in I seem to remember something similar posted a few weeks ago and the answer suggested (again in desperation) was to recreate the pivot from scratch on a new sheet....... __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 10:11 AM	#1
PaulB New Member Join Date: Apr 2002 Location: Paul Burton Posts: 2	I use pivot tables to gather sales data from Access via MSQuery and display for all sales staff. I keep getting redundant data in a field. i.e. I have a column for periods 1 to 12 and currently am at period 7. For some reason I am recently seeing each prd number duplicated when I select the field for this column as if I'm going to supress data. I can supress the duplicates but why am I getting them? Anyone help? This also happens if I had data for a specific area in say the Area column, which now no longer exists in the data within Access, but the pivot table still seems to think that the heading is still there, albeit with blank data.

Apr 15th, 2002, 06:29 AM	#3
PaulB New Member Join Date: Apr 2002 Location: Paul Burton Posts: 2	Chris, Thanks very much for your reply. Yep, I think your right, it's the only way I can see to correct the problem, and as you'd expect, no duplicates in the new pivot table?? Anyone else explain why this happens? PaulB

Apr 15th, 2002, 07:59 AM	#4
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Thought I posted a question and forgot about it! Two Paul B’s on the board, mine with a space yours without. Paul B