Forum Discussion
PIVOT TABLE DUPLICATES
Why is the pivot table giving me multiple totals for one location (GMH)? How can I correct?
Row LabelsSum of HOURSSum of $Grand Total1054.7$135,851.00
| BEH | 108 | $14,040.00 |
| GMH | 120 | $15,600.00 |
| GMH | 42 | $5,460.00 |
| GMH CC | $12,480.00 | |
| GREER | 42.7 | $6,091.00 |
| HILLCREST | 6 | $780.00 |
| LAURENS | 24 | $6,000.00 |
| NGH | 120 | $16,800.00 |
| OCONEE | 96 | $13,560.00 |
| PA WORK | 84 | $5,880.00 |
| PWD | 408 | $38,640.00 |
| (blank) | $0.00 | |
| GMH | 4 | $520.00 |
1 Reply
Hello
It could be that some entries with GMH have an extra space at the end or an invisible charcater.
