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

2 votes397 views1 answer
How to override material ui css
CSS
0 vote332 views1 answer
Compass font awesome
CSS
1 vote323 views2 answers
Centralizar div verticalmente css
CSS
8 votes354 views3 answers
Text break css
CSS
0 vote318 views2 answers
Css disabled cursor not allowed
CSS
0 vote315 views2 answers
Box-shadow: 0px 4px 8px rgba(164, 188, 223, 0.15);
CSS
-1 vote290 views1 answer
How to make div possion top in css
CSS
1 vote320 views1 answer
Css auto heigh div
CSS
5 votes325 views4 answers
Inset css
CSS
0 vote329 views1 answer
Postcss plugin
CSS