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

27 votes385 views3 answers
Align div to center of screen
CSS
0 vote377 views1 answer
Align items in span to center
CSS
0 vote365 views1 answer
Css hide mark border
CSS
0 vote374 views1 answer
Htacess mono-site
CSS
0 vote339 views1 answer
Bootstrap 5 tutorial
CSS
0 vote368 views1 answer
Css in head or body
CSS
0 vote410 views1 answer
Numpy not installling
CSS
0 vote427 views1 answer
How fixed image at top
CSS
0 vote347 views1 answer
Width not responding to css in table
CSS
12 votes354 views4 answers
On hover display another div css
CSS