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

13 votes227 views1 answer
W3schools keyframes
CSS
0 vote228 views1 answer
How to do stuff in css
CSS
0 vote238 views1 answer
Mat slider custom color
CSS
1 vote236 views1 answer
Gatsby hide scrollbar
CSS
0 vote239 views1 answer
Why is there whitespace on the top
CSS
2 votes254 views1 answer
Journalctl last 100 lines
CSS
164 votes249 views4 answers
Html head css link
CSS
1 vote233 views1 answer
Css placeholder text truncate
CSS
1 vote236 views1 answer
Insert background image css error
CSS
0 vote229 views1 answer
Bootstrap put button on one line
CSS