Forum Discussion
Pivot Table separating date field into year and quarter
when i create a pivot table and select the date field, it doesn't pull the data in as Dec 12, 2018, etc. it pulls the data into the pivot as year, and quarter. See screenshot below. how do i fix...
You may remove Year and Quarter fields when created or in options disable that setting
This option might be disabled in office systems! try the other way!
Could you please share bit more, for which Excel version/platform it is disabled?