Sort by an expression

[zestygirl]

Hi, All!

I have a report that adds up the total number of items sold, and groups by item. So, I've sold 18 of part a, 25 of part b, and 100 of part c.

How do I sort by the calculated field (which I've named Sum Total) so that highest sold items sort at the top?

Any suggestions?

 

[Liv Manto]

go to the report properties, click on record source,

it will ask you if you want to invoke query builder

drag all your fields, then create another field that calculates total.

sort it desc or asc by the additional calculated field.