# KPI for each individual item in Sharepoint list

### Question

• Hi,

I have created KPI List. My reqirement is i have one list containing all project names with estimated budget.
Now i want to create KPI for this list based on budget, i.e., want to show indicator based on each individual item estimated budget.

But what i am able to do is based on No. of list items (or) based on %of list items (or) based on Sum, Maximum, Average, Minimum.
But my requirement is want to display indicator for each item in a list.

How to do this, Any ideas will be appreciated.

Thanks,
Neerubee
Thanks & Regards, Neerubee
• Moved by Monday, November 16, 2009 10:33 AM KPI q go to BI (From:SharePoint - Development and Programming)
Monday, November 16, 2009 6:40 AM

### All replies

• Neerubee,

You can accomplish by converting the list view in XSLT or by using calculated field column

Color Coding – Formula Generator

Best Regards, G Vijai Kumar | My Sharepoint Blog
Monday, November 16, 2009 6:57 AM
• HI Raj,

I don't want by using calculation, because i have a list for example.

Project Name                      Estimated Budget

XYZ                                      250000
PQR                                      500000
ABC                                      750000

Now i want to check my goal is 500000, Now for each project have to show indicators. Not based on Average, %, Min, MAx etc..........
And my list is dynamic one, if we keep on adding the projects, it should automatically update indicators.

Hope you understood.

Thanks & Regards, Neerubee
Monday, November 16, 2009 7:05 AM
• Neerubee,

You can show indicators for each items in a list by using calculated field, all you have to do is by using below formula try to create a calculated field in the list name it as Value

="<DIV><IMG src='/_layouts/images/KPIDefault-"&IF(AND(Value>1,Value=<25000,"2.GIF",IF(AND(Value>25000,Value=<50000,"1.GIF",IF(AND(Value>50000,"0.GIF","Chartreuse"))))))&"'></DIV>"

Now to render the KPI default images you have place the Javascript in CEWP as said in this thread

Note: If you face any problem in rendering the KPI default images, make sure that Estimated Budget column is of Number type
Best Regards, G Vijai Kumar | My Sharepoint Blog
Monday, November 16, 2009 7:26 AM
• I agree with SP RAJ.

You don’t need the KPI list for your requirement.

Wednesday, November 18, 2009 8:43 AM