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

0 vote158 views1 answer
Vuetify width of textfield
CSS
0 vote161 views1 answer
Td min-height not working
CSS
0 vote170 views1 answer
Materialize css icon
CSS Materialize
1 vote185 views3 answers
Rainbow text css
CSS
46 votes132 views6 answers
Font color css
CSS
0 vote156 views1 answer
How to apply css on react chartjs
CSS
4 votes117 views1 answer
Grid mdn
CSS
2 votes172 views4 answers
Sieve of eratosthenes
CSS
38 votes155 views3 answers
Css breakpoints
CSS
1 vote158 views2 answers
Dropdown on hover
CSS