Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Pivot Table, duplicated data

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Paul Burton
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ::

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Paul Burton
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •