Dear All,
The Column C is having Dates, Column D with forumula =TEXT(C2, "MMM-yy;;") to get the Month name. When I create Pivot table it shows as below:
Apr-16
Dec-15
Feb-16
Jan-16
Jun-16
Mar-16
May-16
Nov-15
Oct-15
Sep-15
This should be starting with Sep-15 and ending with Jun-16.
Can anyone help me on this.
Gem
Bookmarks