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

15 votes114 views2 answers
Transition background gradient
CSS
0 vote122 views1 answer
Bootstarp 5
CSS
21 votes104 views6 answers
Gradient image css
CSS
1 vote121 views2 answers
How to make hr class bootstrap full width
CSS
1 vote112 views1 answer
Css media queries pc and mobile
CSS
0 vote100 views1 answer
How to make gray ufing rgb in css
CSS
0 vote112 views2 answers
Wpa avoid reload with swipe
CSS
-1 vote102 views1 answer
Tachar texto css
CSS
1 vote115 views2 answers
Change the weight of a bold font css
CSS
-1 vote111 views2 answers
Navigation bar css
CSS