Totals in descending order using an expression

[not a code fan]

Hi there

I have a report which shows the sales totals of ladies clothes for 11 shops. I have created the expression "=Sum([1 Ladies Clothes Sales])" to do this, my only problem is i don't know what to add to this expression to put the totals in descending order. Can you help?

Thanks

 

[sportsguy]

put this statement in the correct location in the
sorting and grouping box.

I am assuming that this is a text box total in a detail record.

"=Sum([1 Ladies Clothes Sales])"

you can do this at any level, you just have to make sure
you get the sorting and grouping at the right level.

sportsguy