SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Jun 15 '12 at 15:21

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

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.

share|improve this answer
Really sad ... :-( – Sebastian Jun 18 '12 at 16:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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