I have an issue where I've created a report to pull information from multiple sheets and want to do two "groupings", one by "type" which is 3 Month, 6 Month, or 12 Month and then by "owner". Sorting by owner is no issue. When I group by type I want it to be in numerical order but whatever I do, it doesn't sort properly.
If I sort ascending then it sorts 12 Month, 3 Month and then 6 Month. If I sort descending then it sorts 6 Month, 3 Month and then 12 Month.
How do I get it to sort so it shows up 3 Month, 6 Month and then 12 Month?