Sorting Total in a Categorized view

I have a view with one category sorted in Ascending Order. I am trying to get view to sort by the Total in each category in descending order.

View looks something like this:

Column1 : Categorized

Field : PlannerName

Column2: Total, Hide Detail

Formula : 1

Any idea, how you can get this to sort by Category’s Total? I need for Column1 as is shown.

Thanks in advance.

Subject: Sorting Total in a Categorized view

can’t you invert the order of the columns