Top 10 customers odoo

query = "select sum(s.amount_total) as total , s.partner_id,
c.name from sale_order as s inner join res_partner as c 
on s.partner_id =c.id  group by s.partner_id,c.name
order by total desc"
//this will return the sum of amount_total group by custmer name ,
//you need to put this value inside the  self.env.cr.execute(query)

Similar codes

9 votes116 views1 answer
Full page background image
CSS
0 vote127 views1 answer
Jpa select date format
CSS
0 vote122 views1 answer
Css scroll fixed content
CSS
0 vote155 views1 answer
Ngrok host header change
CSS
0 vote123 views1 answer
Flex box divs squeeze together
CSS
0 vote120 views1 answer
Prevent mailto href indexing
CSS
2 votes70 views1 answer
Fix nav bar to left css
CSS
4 votes123 views2 answers
Import fontawesome
CSS
1 vote116 views1 answer
Scss percentage
CSS
0 vote118 views1 answer
Prevent css animation reset
CSS