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 using Sharepoint 2007 and sharepoint designer, and I am using multiple sharepoint lists that have the same column types (# required, # complete, % complete) that shows the training status for different departments in my organization. For example, I have List1 (Sales), with a row, Title: safety training, # required (number of people in that department): 10, # complete: 8, % complete: 80.

List1 goes into KPIList1 and is displayed on a KPI webpart on the Sales page in my site collection (Lets call it Dunder Mifflin).

List2 (Administration) is a similar list (#required: 4, # complete:2, % complete: 50) that is displayed on its own KPI webpart on the Administration page in the same site collection.

The endstate is an overall KPI on the main page that reflects the overall safety training status for the organization (in this case 65% complete). I want each department to be able to update their own training status and have that automatically update the Overall KPI.

What I've been trying to do is import the rows from List1 and List2 onto an "overall" sharepoint list (List3), so I can calculate an average of the two, either in the List3 sharepoint list or in a KPI list.

I tried going the data view route, but to my knowledge it won't let me calculate an average and I don't think I can display the data view in a KPI webpart. You can probably tell from reading this that I don't have much programming experience, so step-by-step directions and/or screenshots are very helpful.

share|improve this question
From a glance what you need to do is join the lists? Or do you want the data to be sequential? A join would put the rows side by side, sequentially they would be merged (ie the columns are the same) If it is a join then you can perform joins, not sure if it will work with the KPI webpart as you said. 2010 is far more powerful for this sort of work. Since I don't have an exact answer for you Stephanie at the moment I won't put it as an answer, but if this works, please reply to your post as the answer. List joins:… – Hugh Wood Dec 3 '12 at 12:28
I ended up using the data view to join my lists but I was unable to set it up in a KPI. Because of that I added an extra column to my data view and used conditional formatting to simulate the KPI status. – Stephanie Dec 11 '12 at 16:24

Your Answer


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

Browse other questions tagged or ask your own question.