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 vote195 views3 answers
Bootstrap table text vertical align center
CSS Bootstrap
0 vote131 views1 answer
Css broken image has top margin?
CSS
0 vote161 views1 answer
Liste commandes disponibles linux
CSS
57 votes138 views2 answers
Hegith specific css in media query
CSS
0 vote125 views1 answer
Como fazer listrada css
CSS
0 vote168 views1 answer
What css vmin
CSS
0 vote136 views2 answers
Drop function postgresql
CSS
1 vote277 views1 answer
Cypress element css
CSS
37 votes140 views4 answers
Select even child css
CSS
0 vote206 views1 answer
Css bootstrap carousel fade how to add fade in up text
CSS Bootstrap