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 vote180 views1 answer
Ipad pro css
CSS
0 vote161 views1 answer
Scss add class to body
CSS
5 votes190 views2 answers
Scss hover
CSS
0 vote198 views1 answer
Delete after content css
CSS
0 vote197 views1 answer
Linear gradient farthest-corner code css
CSS
2 votes145 views1 answer
Xpath vs css selector
CSS
0 vote187 views1 answer
How to use css print page break with float
CSS
0 vote183 views6 answers
Install canon mf211 printer ubuntu
CSS
48 votes188 views6 answers
Html font size
CSS
0 vote187 views1 answer
Css prevent text wrap
CSS