Search code examples
sharepoint-2010dashboardperformancepointkpi

Calculated KPI in Dashboard Sharepoint


I have two KPIs in the ScoreCard in Sharepoint Dashboard Now I want to include an additional row between these KPIs in the ScoreCard which shows the division of value of these two KPIs...

Actual.. 10
"New column" {Actual/Target} i.e. 10/12
Target.. 12

I am sure how to implement this

It will be great if I you give me clue about how to implement this or any link regarding the same


Solution

  • You're actually creating an additional Target, with a new name (New Column). In your case, you want to show the Actual as a percentage of the target. You can simply set your displayed value to be a percentage and set your indicator thresholds to their particular range and you should be good to go.

    I will be happy to provide more detailed directions if needed.