10 Replies Latest reply on Jul 23, 2018 1:26 PM by Aileen Rotondo

    Filtering all years except 2018

    Aileen Rotondo

      Hello,

       

      I am trying to filter all years (except 2018) to just see the headcount for the month of december.

      I have it done here in this data with the headcount numbers hidden, but I want to see the current headcount for 2018.

       

       

       

      __________________________________________

      Created Calculation Headcount

       

       

      Message was edited by: Aileen Rotondo This is some sample data. I just need to count the number of employees at the end of every year. I was doing this by creating headcount and counting the unique usernames per year every December. But this may not be the most accurate way to do this. We could also count all of the employees that are Null in the "end date" column (employment not ended). That seemed harder to do.