Totals value (sum) of child rows displayed in parent list

I have 2 lists, with a 1:n relationship, there are many child rows relating to one parent.

I am looking for a way to display the sum of values from the child rows and show it on the relating parent item, I would prefer that the value is periodically copied to the parent list if possible but a formula would be okay if not

The items in the child list are lookups from an external content type (sql)

full access to site and share point designer 2010

Forgot to mention if possible to also be able to separate by a date field on the child list,

eg for parent list:

title, estimated value, sum of child (2010), sum of child (2011), sum of child (2012)

the lookup for the child list includes a date and value

Also: no public access to site, remote access via skype or teamviewer

Skills: Javascript, jQuery / Prototype, Sharepoint

See more: sql sum child rows, share point designer, Value, sharepoint javascript, rows, parent, child, javascript sum sum, sharepoint 2010 site, access rows, formula sql, sharepoint 2010 parent child, access formula, sql 2012 sharepoint, access sharepoint, access 2010 sharepoint, sharepoint list, sql formula, item list, child relationship, sharepoint 2010 lists, sharepoint 2010 javascript, sharepoint designer 2010, parent child, site value

About the Employer:
( 1 review ) London, Canada

Project ID: #2531959

6 freelancers are bidding on average $53 for this job


Hello, I am interested to help on this. Please check pm. Thanks.

$50 USD in 1 day
(32 Reviews)

I can handle this job easily please contact with me

$100 USD in 0 days
(7 Reviews)

Hello, we are a group of programmers based in Sheffield, UK offering 7 years experience in php, .net, c#, jquery, css, python and c++. I am proposing to carry out tasks required for this project and deliver it within 2 More

$40 USD in 0 days
(5 Reviews)

Skilled web-developer. Experience in jQuery about 3 years. Have thoughts about how to deliver your project.

$40 USD in 1 day
(0 Reviews)

I am a PHP programmer . I have 4 Year of experience in web development. I have create many website for the small and large business. I have Strong knowledge of PHP, CakePHP,Html, OsCommerce,Css, JavaScript, Ajex, Jquer More

$40 USD in 2 days
(0 Reviews)

Custom software development (<b><i>Removed by Admin</i></b>)

$50 USD in 1 day
(0 Reviews)