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

-1 vote207 views1 answer
Line break inside content css
CSS
5 votes221 views3 answers
Set scroll position bottom in div css
CSS
0 vote202 views1 answer
How to allow text to be copied in an input element ionic
CSS
1 vote190 views1 answer
Input start typing in the center
CSS
42 votes208 views6 answers
Text color css
CSS
30 votes194 views4 answers
Opacity color
CSS
0 vote196 views1 answer
How to write text in middle of straight line in css
CSS
0 vote196 views1 answer
Backwards text css
CSS
10 votes184 views1 answer
Css when click select another class
CSS
1 vote187 views1 answer
Css how to dynamically put div in front of another
CSS