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

8 votes120 views2 answers
Css resize checkbox
CSS
0 vote110 views1 answer
Ratio bootstrap
CSS
0 vote116 views1 answer
Css diminuer épaisseur trait
CSS
22 votes125 views2 answers
Css set styles for input text
CSS
1 vote124 views1 answer
Change order columns bootstrap
CSS
3 votes131 views1 answer
Css first td
CSS
1 vote116 views1 answer
Hardball rifler
CSS
0 vote114 views1 answer
Shrink a div by 50%
CSS
0 vote112 views1 answer
Shadow on hover class on card bootstrap
CSS
3 votes112 views2 answers
Move css background image
CSS