Sort by sum (1 Viewer)

[adi32]

I have a report with products like this
sum of product1 100kgr
sum of product2 200kgr
sum of product3 10kgr
sum of product4 50kgr

And i want to sort them by sum like this
sum of product2 200kgr
sum of product1 100kgr
sum of product4 50kgr
sum of product3 10kgr

how can i do that?
when i put in sort order the sum first and the product second
i receive that
sum of product2 100kgr
sum of product2 100kgr
sum of product1 100kgr
sum of product4 50kgr
sum of product3 10kgr

 

[llkhoutx]

Have the sum created in a query and then use that query as your report recordsource.