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'm configuring a KPI for my sharepoint 2010 site. Take this example of a "projects" list and a "project progress" field in this list which is shown in percentage. I want to configure a KPI for this field to show the average project progress.

now my problem is in the data mappings window. After I click change source and select my created data source, in the "dimensional data source mapping" window I select the appropriate field (namely, "project progress"). The problem is that I can not change "Aggregate members by" to Average, which is by default set to "Default". The reason is that it is disabled (grayed out).

I've searched everywhere without luck. Every blog and tutorial assumes that this part of the window is enabled. Any help is greatly appreciated.

share|improve this question

migrated from Dec 19 '11 at 11:53

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

If the data type is not compatible with taking an average, the "average" aggregation type will be disabled. Also, please be sure that the data source is ADOMD and the "Use MDX tuple formula" is NOT checked.

share|improve this answer

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.