Find my approach, for the first part of your challenge, below as reference and stored in attached workbook version 9.3 located in the original thread.
1. Find /: find([Items],"/")
2. Position: int(mid([Items],5,[find /]-5))
Defaulting max value in filter is a different "cookie";)
Shinichiro Murakami once again a "defaulting-challenge";)
This time based in a filter. Could you comment once again.
Thanks in advance.
sorting item_nalmai.twbx 12.5 KB
I think your approach is reasonable.
Basic concept is create other field with changing string to integer, or date.
Then sort with using that field instead of "Items".
Thanks for prompt reply.
Could you also elaborate second part of Mafalda's challenge
"The other question that I have if is it possible to show the maximum result as the default on filter card?"