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

3 votes274 views1 answer
Font family comic sans ms
CSS
0 vote258 views1 answer
Inset boxshadow
CSS
0 vote269 views1 answer
Square with 2 colors css
CSS
0 vote266 views1 answer
All ipad Resolutio css
CSS
0 vote296 views1 answer
Bootstrap dropdown in accordion problem
CSS Bootstrap
2 votes260 views3 answers
How to make a html css js editor
CSS
6 votes280 views5 answers
Bootstrap icons
CSS
0 vote263 views1 answer
If child elemnt is hovered do changes to the container css
CSS
22 votes262 views5 answers
Css center grid
CSS
0 vote274 views1 answer
P{ color: blue; font-size: 14px; }
CSS