Sort order with summary field problem

[NeuroPulse]

Greetings again -)

Trying to get records to sort like this:

Region, Price

B, $6

B, $7

B, $9

C, $5

C, $6

C, $8

A, $4

A, $8

A, $9

That is, list the regions in order of which has the highest lowest price.

The lowest price in B is $6 which is higher than the lowest prices in C and A.

So I want to put the prices in order for each region, then put the regions in order according to the one with the lowest price.

Can this be with Sort? BY using a summary field somehow?

If not, with a summary report?

Been struggling with it.

Thanks

[comment]

Like this?

SortReorder.fp7.zip

[Lee Smith]

This questions sounds a lot like your other question Link

[NeuroPulse]

Wow. How did you figure that out so fast. I guess I didn't fully understand how reordering with a summary worked. Thanks.