I have a table with Subtotals and use standard table visuliation with collapsilbe items.
The table contains State - City dimensions (grouping hierarchy) and Sales measure.
Currently the table is always sorted by State.
As I see in the doc: https://docs.looker.com/exploring-data/visualizing-query-results/table-next-options
“The leftmost subtotal is always sorted. When you sort by multiple columns, subtotal columns are given precedence”
I need to get States sorted by Sales meaure in descending order, i.e. States with higher sales on top. And still I need the posibility to expand the cities also sorted by Sales (desc) within state.
How can I do this?