Hello. I'm looking to answer the following questions with Pivots but I'm not sure how to do it. Can I answer any/all of them? Thanks. Spreadsheet attached and questions below.
Number of customers in Year 3
Number of customers in Year 3 AND at least 2 claims in their 3rd year
Number of customers with 3 years of data AND at least one claim filed in any of their years
Number of customers with at least 2 years of data AND at zero claims filed
Bookmarks