Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    Location
    Sheffield, Yorkshire, England
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a pivot table in which one data element in the row area displays incorrectly - it shows "81" instead of the correct value of "90413". Refreshing the pivot table has no effect. Can anyone suggest a way of correcting this?

    Thanks
    Graham

  2. #2
    Star Lounger
    Join Date
    Oct 2002
    Location
    Sheffield, Yorkshire, England
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I've found a solution. Altering all '90413' codes to something different in the data, refreshing the pivot table caused the pivot table to display as expected. Altering all the codes back to '90413' and then refreshing again displayed the pivot table correctly.

    Interestingly when I deleted the offending records and refreshed and then added the records back and refreshed again didn't sort out the problem. The offending records still showed as '81'.

Posting Permissions

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