Dont get ride of the table just do not use it to get that answer.
make some interaction on the table and bar chart to switch back and forth form the two, or put both on the same screen.
I had a similar situation (sorry should have said that before) where in overview they needed to know what was the highest dollar amount then from there they could go into the detail (table) for that section or if they click anywhere on the bar chart it goes to the unfiltered table. I was difficult for me as well to get the table to order by high amount, I think to get close to want they wanted I had to take out some of the grouping columns but left them as filters in the table format.
it might be possible with all the columns, but I would have to get in there in a hands on way to play around with the ordering myself with what you have to see if I could manipulate it.
My hands on would just be trying out what logically seams right and see what that does then keep trying to see if I get close to what is wanted or finally get it.
The costume ordering might be helpful https://www.dundas.com/support/learning/documentation/analyze-data/define-custom-hierarchy-sorting possible setting no order to the ones you do not want it grouped by?
