Month in Heading Not Sorted in Pivot table

[vs_suresh]

Dear Gurus,

I have a formula to arrive month in the main file
(=TEXT(H6, "mmm-yy")

Now when I create pivot table with month as one of the header, the header label is not sorted out.
It should suppose to come as Jan-16, Feb-16 & Mar-16. Instead, it is coming as per the below...

Name	Status	Feb-16	Jan-16	Mar-16	Grand Total
John	Closed	10	4	3	17
David	Closed	5	9	1	15
Micheal	Closed		2	1	3
Guru	Closed	3	3		6
Grand Total					41

<tbody>
</tbody>

Please help me to resolve this issue...

Regards,
Suresh

 

[FormR]

Hi, instead of using your formulated column in your pivot table COLUMNS row, you could add column E and then right click the "Column Labels" and choose "Group" and select "Month" and "Years" from the "By" list.