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

10 votes141 views2 answers
Css how to change font colr
CSS
1 vote160 views1 answer
Scroll background still
CSS
18 votes162 views6 answers
Text outline css
CSS
115 votes143 views6 answers
Css padding
CSS
8 votes146 views5 answers
Flex margin between items
CSS
1 vote137 views1 answer
Login
CSS
0 vote140 views1 answer
Center text html css position fixed
CSS
0 vote158 views1 answer
Css tr border radius
CSS
7 votes185 views3 answers
Transition shorthand css
CSS
3 votes912 views1 answer
Input text size css
CSS