I have a number of different SharePoint lists in SharePoint 2007 that each display financial data. This aggregate sum for each table is then displayed as a KPI. Now I want to take these 6 different KPI values and sum them up to show a single total goal and actual for all the tables.
I can't seem to figure out how best to do this. I had thought Excel could help, but it looks like updating data from SharePoint lists was deprecated. I saw a reference to Access 2007, but I figured I'd see if there were alternate, easier solutions. Thanks.