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

72 votes349 views6 answers
Css center position absolute
CSS
5 votes309 views2 answers
Css text cut dots
CSS
3 votes281 views3 answers
Remove on click border
CSS
0 vote284 views1 answer
Punderline none
CSS
13 votes290 views7 answers
Animate.css
CSS
0 vote331 views1 answer
How to make multiple borders using box shadow in css
CSS
0 vote288 views1 answer
Flex box writing sideways text top to bottom
CSS
5 votes279 views2 answers
Style disabled button
CSS
0 vote262 views1 answer
Text width tailwindcss
CSS
0 vote288 views1 answer
Css using the same background-color as the parent background
CSS