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 vote173 views1 answer
Repeat autofill css grid minmax
CSS
0 vote172 views1 answer
Css center modal vertically
CSS
1 vote166 views1 answer
Border bottom under text only
CSS
0 vote193 views2 answers
Fix materialize form label not working
CSS
36 votes173 views4 answers
Adding gradient to text color
CSS
48 votes178 views3 answers
Custom scrollbar
CSS
37 votes164 views5 answers
Display css
CSS
18 votes169 views5 answers
Col-md-6 bootstrap
CSS
0 vote264 views1 answer
Nokogiri xml diff
CSS
0 vote191 views1 answer
How to align divs in a row
CSS