I am having sheet with pivot chart. Row header containing Wk #-Year (04-2018, 06-23018, 04-2019, 09-2019 so on). When I tried to sort in pivot, it is sorting with respect to week number only not considering the year.
snip.JPG
Please help me to sort properly.
Advance thanks..!!
Bookmarks