2 Replies Latest reply on Apr 19, 2018 10:06 AM by Aradhana Lakshman

    Counting Distinct Id's Within a Year and finding percent total for that

    Aradhana Lakshman

      I have three years 2008, 2012 and 2016. And I have IDs. I want to be able to count each of these ID's within a category, within a year and calculate it percent to the total within that year.

      If I am looking at 2008, I have 6315 IDs and cat 'A' has 5030 IDs- making Cat 'A' 80% of the total for 2008.