Forum Discussion
Kwhite37
May 23, 2024Copper Contributor
pivot table date formatting not working
I want my pivot table to show the date format that exists in my source data (mm/dd/yyyy). The pivot table is automatically grouping the date into Year and Quarter, and after deleting these from the s...
Detlef_Lewin
May 24, 2024Silver Contributor
You removed the fields from the rows area or columns area. The dates are still grouped.
Right click in the date field and choose "Ungroup".