Pivot Table, duplicated data

[PaulB]

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]

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]

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]

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