Pivot report not showing the date as per the source data format

[vijavad]

Hi Folks,

I have Master data and the date field is in the format "DD-MMM-YY" and from this Master data i have generated a Pivot report with several other fields and after generating report the date format i see as only MMM but not " DD-MMM-YY"format like what my source data has. I tried format cells option and went to date formatting but no use.

So can somebody help me in fixing this issue in EXCEL 2016.

 

[SpillerBD]

It sounds like Excel has tried to be helpful and applied grouping to your date field.
If so, Ungroup by Right+Clicking the field and choose Ungroup.
You still may need to set the formatting...

 

[vijavad]

Hi Thanks perfectly working but i see some changes after refreshing data the DATE format is getting changed and its not as same as the source data.

One more few other feilds are empty and i tried refreshing but still the data is empty. Any idea why the source data is not reflecting

 

[SpillerBD]

If the master data is a ranged source instead of a Table source, additional data may no be captured in the update. Could even be lost.
Your data source for the Pivot Table should be a Table or from a query using Get and Transform (on a Table).