Sorting with sub-totals causes strange results | Community
Skip to main content

Sorting with sub-totals causes strange results

  • December 15, 2022
  • 0 replies
  • 0 views

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?