Forum Discussion
Catherine Klopper
Jun 26, 2018Copper Contributor
Pivot table displays only month of full date - can't display year.
Hi. I have created a pivot table from a data set. One of the fields in the data set is a date field (and I've checked, Excel is recognising it as a date in the format mm/dd/yyyy). However, when I ...
- Jun 26, 2018
Catherine,
right-click on a month or date and select "Ungroup".
Detlef_Lewin
Jun 26, 2018Silver Contributor
Catherine,
right-click on a month or date and select "Ungroup".
Rennae_Hippleripple
Jul 01, 2024Copper Contributor
This was an absolute life saver! TYSM