Forum Discussion
GordH42
Apr 20, 2022Copper Contributor
Unexpected Pivot Table Header Changes by itself
Hi, I have created a pivot data but the header column data seems to have changed when compared to the actual raw data. Below is a picture of the raw data where the Property is the row, Date2 is the columns and Amount is the data value. With reference to the highlighted rows, the Date2 is showing Jan-01, Jan-02 and Jan03. You would expect to see this in the Pivot table. However, in the following pic of the pivot tabe (see highlighted column headings) all the dates appears to be Jan-03? You can see the corresponding data of 44 appear there but some how the data for the headings changed? Any help please.
26 Replies
- Detlef_LewinSilver ContributorPlease provide the workbook. Delete or change sensitive data.
- GordH42Copper ContributorSorry new to this platform. I replied perhaps not against your message. So here it is again. I tried to drag and drop but no upload. Is there another way to provide workbook?
- Detlef_LewinSilver ContributorDid you open the full text editor?