Sort report by revenue

Alane

Hello,

I am trying to sort a report by revenue descending to ascending. The primary column is states. The report automatically sorts by primary alphabetically. I do want it grouped by states but would like to see the revenue from highest to lowest. Any suggestions?

KPH

Are you trying to group by state and then have the state with the highest total at the top? So, in this example the states would be the opposite way around:

Or do you want to sort the rows within each group, like it shows?