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...
abrown520 Try right-clicking any of the date items (Year, Quarter or Date) and select Ungroup from the context menu.
Worked well! Thanks Chap!