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

50 votes201 views6 answers
Backgroud color css
CSS
-1 vote161 views1 answer
Css tricks position
CSS
0 vote222 views1 answer
Progress bar bootstrap border
CSS Bootstrap
4 votes169 views3 answers
Css moz webkit generator
CSS
0 vote149 views1 answer
How to change height font css
CSS
0 vote145 views1 answer
Csshx iterm2
CSS
3 votes156 views2 answers
Make image not draggable css
CSS
0 vote161 views1 answer
Css layers over background-images
CSS
42 votes156 views6 answers
Text overflow css
CSS
1 vote163 views1 answer
Alert without page refresh
CSS