A keyword to keep in mind is 'Bias'
So the sort needs to be executed in the reverse order to bias the results of the next .
Your sort also has conflicting requirements. You can't have Series and Title work together. eg Book2 TITLE is Zebra, 3 is Apple, 4 is 3 bodies
The Title sort result should be: 3 bodies, Apple, Zebra,
but the Series sort is the reverse
you can't have both together
If you want to see the
Author in
Title order, you sort by Title, then Author

You can test your plan by clicking the column headers in the EXACT order you will put in the tweak (2 clicks reverses the column sort)
Series can add even another layer when there are multiple Authors participating in the same series. {Authors} when sorted must
all be the same ones (the order shown in the column seems to be ignored)