Dear All,
I have KPI list is base on other sharepoint list.
For example, I have two Dept.
List 1 : HR list colume are Old cost,new cost,and Saved(calc by old-new)
List 2 : IT list column are the same.
the KPI list indicate the dept total save cost.
but how can i get the total save cost of sum dept.
KPI Goal Value
HR $1000 $5000
IT $1000 $800
Now I want to get the total $5800 but dont want to sum by myself because too many dept
Thank all