Pivot Table Sort order flexibility

When selecting the sort order in a pivot table. It would be nice to select the order by the item. We find that in some cases sorting the order by least to greatest or A-Z does not adequately meet our needs. For example when a list is A,B,C,D,E we find that sometimes if we could show C,D,A,B it would communicate to the audience beter.