I created a simple table report in Explore, added row-level subtotals and final totals and everything looks great.

However, when I change the sort from A-Z to Z-A it ends up putting the subtotal lines at the bottom of everything, rather than beneath the grouping they represent.

Support told me this was as expected and there are workarounds, and I can raise a product enhancement request - but surely this is plain and simply not working as anyone would expect. Or am I missing something?

Any thoughts?