Pivot Table

Hello, i’m not able to sort my pivot tabel by month. The pivot is always sorted from A to Z or Z to A.
That means that pivot starts with Apr, Aug, Dez, etc.

I’m using the following formular to read out the month from div. field: =TEXT(E1171;“MMM”). It will also not change if I enter the month manualy.

Hello @Willi

This behavior is not a bug, Pivot Tables do not have options for sorting by month natively. Have you seen any processors that allow that?