Here is my approach:
1) Created a calculated field to get active contracts:
2) Second calculated field using calc 1 to get only active products:
3)Third calculation for getting distinct products :
4) Fourth calculation to calculate coverage:
5) Final view:
Please find the solution sheet attached created using v10.2
Hope this helps.
Contract Coverage.twbx 25.1 KB
Tushar you are a genius! You've nailed it.
Thank you very much for taking the time to look into this and help me out - that was exactly what I was after.
Happy to help you