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
Bookmarks