You appear to be asking 2 different questions (although similar)
1) Kindle:
Kindle collections PI only works fully on older models (Reader: Kindle does not tell us much

), but do consider the
Metadata Plugboard {series}-{series_index}-{title} -> {title}
2) Calibre: Click the Column TITLE to sort (this is pretty much standard behavior for any
program with columns). The arrow indicates the sorting direction. Click again to reverse.

Want Title sorted by Author? First sort by Author, then by Title.
Previous sorts (3)
bias the display of later (No you can't force mutually exclusive results)