Hi There
There is a clothing manufacturer who sells items in both adult sizes and children's sizes.
These have different sizing types. For example: adults sizes are measured in 'small', 'medium' 'large' while children's sizes of the same clothing style (white shirt) would be in sizes '08','10'',12','14'
I want a way to sort the sizes in a saved search or report so that the sort order is custom. for example
Item: Size
White Shirt S
M
L
08
10
12
14
How would I create a custom sort order?
The normal sort order in the results tab. i.e.
would not work as the required sort isn't always alpha or numeric or by the three fields
For some clothing styles for example, you might want items that are sorted by all sizes by that colour of clothing (e.g. all blue shirts from small, med,large then all red shirts in 08, 10,12,14) while other clothing styles are sorted in all adult sizes then children's sizes regardless of colour
Is there a way to do this?