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

0 vote337 views1 answer
Make the first item at the very top of the screen
CSS
7 votes360 views2 answers
Change button shape css
CSS
9 votes358 views2 answers
Line in middle word css
CSS
4 votes373 views1 answer
Checkbox input in css
CSS
0 vote358 views1 answer
Css play button on image
CSS
0 vote393 views1 answer
Hovered one element change styles for another css
CSS
2 votes377 views1 answer
Hover effect button css
CSS
0 vote352 views1 answer
What is focus state in css
CSS
4 votes338 views2 answers
CSS shrink image
CSS
0 vote357 views1 answer
My customized css export chrome dev
CSS