Pivot Table Date Field

[mikeymay]

I have a set of data that is in a table format

The Month column shows dates from Jan 2012 to Oct 2024

I have a Pivot Table that is connected to this table and I want to use a filter for the Month to show the total by Client

But when I click on the filter to filter by Month, the options only show the month names rather than 1 January 2012, 1 February 2012, etc, etc, 1 October 2024.

I have no idea what fixes this as it makes no sense what Excel is doing......

Anyone else had this problem or know of a fix?


TIA

 

[RoryA]

That should not happen. It may be worth turning off the automatic date grouping in pivot tables:

 

[mikeymay]

That should not happen. It may be worth turning off the automatic date grouping in pivot tables:

View attachment 119608

That should not happen. It may be worth turning off the automatic date grouping in pivot tables:

View attachment 119608

Unfortunately when enabled and disabled, the issue is still there.

 

[RoryA]

Which build of 365 are you using, and can you put a censored file somewhere that I can have a look at?

 

[mikeymay]

Which build of 365 are you using, and can you put a censored file somewhere that I can have a look at?

Not sure how to do that. I can email directly if you can DM me.

 

[Alex Blakenburg]

Not sure how to do that. I can email directly if you can DM me.

The Forum rules don't allow handling the query directly/offline. Please put a desensitised copy of the workbook on a sharing platform such as Dropbox, Google Drive, OneDrive, Box and make it available to anyone with the Link and post the link here and we can take a look to see what is going on.