Question: months are not in order in pivot table?
Answer: When you create a Pivot Table in Excel that has a date field and is based on data in Excel, you can Group that field by month and the sort will be chronological (January, February, …). ... Within a Power Pivot based Pivot Table, there is no Pivot Table setting that will sort months chronologically.