Analyzing customer claims and renewal rates with pivot tables

Hello. I have a pivot table with six categories (sample spreadsheet attached).

Here are the variables:
1: Customer ID
2: Year (customers that stay with us multiple years, 1....x)
3: Money Due (the price of a contract)
4: Money Received (sometimes customers cancel midway through the year and then we only receive a portion of the money due)
5: # of claims filed (the number of claims that a customer files in a given year)
6: Claims $'s (the amount of total claims placed by a customer in a given year)


I would like to answer the following questions with my pivot point but I'm not sure how to do so:
1) How would I look at renewal rates but ignore cancelled contracts? For just pure renewal rates, I would do a count of total customers by year, but is there a way that I can filter out from the count, customers that have money received that is less than the money due amount?
2) Is there a way that I can isolate customers that have filed more/less than X claims in all of the years that they have a contract? So for example, I might want to see the list of customers that have filed more than 3 claims in EVERY year of their contract? Is that possible?
3) Can I see what % of customers that file 0 claims in year 1, continue to file 0 claims in the rest of their years?
4) What % of customers renew if they have filed at least one claim? What % of customers renew if they file no claims?

I've messed around with the pivot table on my own but I haven't been able to manipulate the data to answer the questions above. Any help would be appreciated.

Thanks