• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

My pivot table is showing the same data item twice

My pivot table is showing the same data item twice

Problem

Your pivot table is showing the same data item two times, effectively treating each instance of the data item as a separate entity. Figure A.6 demonstrates an example of this error.

Figure A.6. Notice that 1/3/2003 is shown in the pivot table twice. There is something wrong here. If these dates are the same, they should be grouped together to give you one calculation, not two.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint