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...
<tbody>
</tbody>
Please help me to resolve this issue...
Regards,
Suresh
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