A simple one probably

I have pivot table which has dates in column field.

The date format is MMM-YY.

However when it makes the pivot table.. Its sort the data by text ( April,
August, January, July,etc)
but not in the date format ...Jan / feb/ march,,,,,

Why is taht

how to resolve