Conditional Filtering in EXcel 2007 Pivot Table

I need to create a calculated field in Pivot table based on Date (Year&Month) and total number of clients for that Date. Thus, when Jan2012 selected from Filter, then the calculated field (denominator) should only pick total number of clients for Jan2012. I have two sets of data one for claims and one for clients. How do I create a Combo Box (or other any other methods) to perform the filtering. Below are samples of two tables + Final Pivot Table:Claim Table (Raw Data)

Client Table (Raw Data)


Final Table (Pivot)
Filter: YrMnth(Combo from Claim & Client Tables)



Thank you

Hi,
See attached a proposal
Consolidate the Claim and Client Table sheet with wizard pivot table
Insert an element calculated for Paid/Client
To get the correct values for field Paid/Client, the report filter Claim & Client should be set to all
When adding or inserting data in tables don't forget to refresh the pivot table
Hope this helps
Best regards

Thank you so much jpr. It worked great. Sorry for late thank you note..been on atrip for a while.

Helal