So I have my sorting for a report setup as Length with A on top (descending) by entire value with a sub sort of Quantity with A on top by entire value.
This is the data I am putting in
Length Quantity 10 200 5 850 5 430 10 560 10 440 6 180 10 60
But the order It sorts into is
For some reason in the sub sort(quantity) the 10 x 60 comes at the end and in the main sort(length) the 6 comes after the 5's.
Length Quantity 10 200 10 440 10 560 10 60 5 430 5 850 6 180
Does anyone know why it acts like this? It doesn't make any sense? 6 it higher than 5 haha.
Also sometimes length will be something like 50" in which case I want it to be at the bottom of the sort or Quantity will be in something like 35 PCS and I would want that to go on the bottom of its length sort.
I am not sure how to do this through the sorting menu though. Is there perhaps a way I can sort them based on some expressions that decide where they should go? (I read on another forum post that reports only sort by the sorting/grouping ui and I am hoping there is a way around that.)
This is what I would ideally like the results to be
Length Quantity 10 60 10 200 10 440 10 560 10 35 PCS 6 180 6 10 PCS 5 430 5 850 56" 180 45" 25 PCS
I hope the example tables help. Thanks for any help!