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

3 votes206 views1 answer
Vh and vw
CSS
0 vote211 views3 answers
Change text in a div css
CSS
0 vote184 views1 answer
Iphone CSS
CSS
1 vote187 views1 answer
Firefox css code
CSS
0 vote252 views4 answers
Scale down image css
CSS
0 vote239 views1 answer
Horizontal checkbox css
CSS
0 vote220 views1 answer
Css keep element on same position among different screen size
CSS
2 votes191 views1 answer
Js confirm yes no before delete
CSS
2 votes194 views1 answer
Not hover css
CSS
3 votes242 views3 answers
Zoom image inside div and move
CSS