Months showing in pivot table

[mcwilso]

Hi All,

I just upgraded to Windows 10 and am now on Excel 2016.

When i do a pivot table with dates it automatically put's a month header above the dates which I would rather not have, is there a way to remove this?


[TABLE="width: 118"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[/TR]
[TR]
[TD]<5/29/2016[/TD]
[/TR]
[TR]
[TD]May[/TD]
[/TR]
[TR]
[TD]29-May[/TD]
[/TR]
[TR]
[TD]30-May[/TD]
[/TR]
[TR]
[TD]31-May[/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[/TR]
[TR]
[TD]1-Jun[/TD]
[/TR]
[TR]
[TD]2-Jun[/TD]
[/TR]
[TR]
[TD]3-Jun[/TD]
[/TR]
[TR]
[TD]4-Jun[/TD]
[/TR]
[TR]
[TD]5-Jun[/TD]
[/TR]
[TR]
[TD]6-Jun[/TD]
[/TR]
[TR]
[TD]7-Jun[/TD]
[/TR]
[TR]
[TD]8-Jun[/TD]
[/TR]
</tbody>[/TABLE]

 

[ghrain22]

*Misread the post*
I originally misread the post and posted an incorrect solution.

I don't have 2016 but I found a few things that may be of interest.

My understanding is that you can remove the monthes in the field list. You can also "ungroup" the fields from one another:
https://support.office.com/en-us/ar...e-report-115339d9-0165-48c5-8850-f73cf53b58be

If you want to keep excel from automatically grouping in the future you can make and edit in the registry:
https://support.office.com/en-us/ar...db2-9f87-5ac262d67b3f?ui=en-US&rs=en-US&ad=US