sharepoint 2007 and excel 2007

See more:

MS-Excel

SharePoint

Hi,
I have an excel pivot table like this:
Report Filter: Project ID
proj_name Status
A 70
B 60
C 80
I have this workbook published onto Sharepoint server through excel services.
On the site i have a choice filter that has all the project ID's. I am able to show this table in a web part and filter the web part by passing parameter from the choice filter to the report filter in the workbook as shown above.
Problem:
I added a KPI webpart that uses the "status" from the above table as its indicator value. What I want to do is that I want to pass the parameter from the choice filter on the site to this KPI web part so that it will show me the corresponding status dynamically accoring to the project chosen.
Can someone help me solve this problem?