Partner Count

Hi All, I have the below To scenarios to get the partner count. Scenario 1--> To calculate the count of partners who did not do sales in last year and did sales in the current year are the new Cust...