Apr 20 2022 10:29 AM - edited Apr 20 2022 10:30 AM
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.
Apr 20 2022 10:38 AM
Apr 20 2022 11:57 AM
Apr 20 2022 12:06 PM
Apr 20 2022 12:14 PM
@Detlef LewinTried in full editor but it says "The file type (.xlsx) is not supported. I guess they don't want viruses. Understandable.
Apr 20 2022 12:27 PM
Apr 20 2022 12:36 PM
@Detlef Lewin It does not allow me as you can see with the error message. Is it because my setting is off somewhere? Not enough privilege? Don't know
Apr 20 2022 12:37 PM
@Detlef LewinI'm presuming it is just a drag and drop option. I don't see an upload button.
Apr 20 2022 12:46 PM
Apr 20 2022 12:49 PM
@Detlef Lewin Sorry you lost me.
Apr 20 2022 12:51 PM
Apr 20 2022 12:55 PM
Apr 20 2022 01:01 PM
Here is what I see. I could be completely blind but I don't see what you are refering to.
Apr 20 2022 01:07 PM
Strange.
Do you use a browser add-in which blocks domains?
If so then try and unblock these domains:
techcommunity.microsoft.com
wcpstatic.microsoft.com
ajax.aspnetcdn.com
clarity.ms
az416426.vo.msecnd.net
Apr 20 2022 01:16 PM
Apr 20 2022 01:17 PM
Apr 20 2022 01:20 PM
Apr 20 2022 01:30 PM
Upload the workbook to a cloud service such as OneDrive, Google Drive, Dropbox or similar.
Obtain a link to the uploaded file and post that link in a reply.
Apr 20 2022 01:40 PM
Apr 20 2022 01:43 PM