I have two sharepoint lists:

  • one with all budget positions
  • one with all cost centers

the budget positions have a lookup column that links to an entry in the cost center list. What I would like to do now, is to have an additional column in the cost center list that shows me the sum of all budget positions linked to this cost center.

Is that possible with SP2010? If not, is there a workaround / other possibility to achieve what I want?

1 Answer 1


There is no out of the box support in SharePoint. And doing aggregations is not the strongest part of SharePoint.

The only real option is to add event receivers to the list with budget postings updating a "readonly" column i Cost Center on every ListItem add, update and delete.

  • Really sad ... :-(
    – Sebastian
    Jun 18, 2012 at 16:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.