Forum Discussion

GordH42's avatar
GordH42
Copper Contributor
Apr 20, 2022

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

    • GordH42's avatar
      GordH42
      Copper Contributor
      Sorry 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?

Resources