Pivot Table - Date Order

Hello Alan,

Thank you for your question. The first thing you can try is once you have brought the dates into the pivot table, in the Analyse tab, select Ungroup in the Group section. Then select Group Field and select Year and Month. Hopefully, this will group your dates by year and then by month.

If this doesn't work for you, please post in the forum again so that we can find a different solution.

P.s. please make sure that your dates are entered correctly, e.g. 21/01/2022.

Kind regards
Marius Barnard
STL