Pivot table (List of dates in drop down are out of order)

[DashboardNovice]

I have a date field in the "Filters" box of a pivot table. When I select the pull down arrow, the dates are not listed in sequential order. They are mixed up.

What causes this?

How can I get these dates in the proper order?

 

[xlstime]

Can you please upload same data set.

You can also refer below urls

Right click on the Pivot Table - "Pivot Table Options" - Select the "Display" tab - The bottom section controls the "Field List" -Sort A to Z / Sort in data source order

https://support.office.com/en-us/ar...votTable-e41f7107-b92d-44ef-861f-24430830450a

http://www.joellipman.com/articles/microsoft/excel-pivottable-filter-list-ordering.html

I have a date field in the "Filters" box of a pivot table. When I select the pull down arrow, the dates are not listed in sequential order. They are mixed up.

What causes this?

How can I get these dates in the proper order?