2 Replies Latest reply on May 1, 2018 11:13 AM by Gary Martins

    Count Items Not Shown in View - 10.2

    Gary Martins

      Hello,

       

      I have two data sources which are blended upon a date. I am counting the number of employees by year from data source A, but can't seem to figure out how to count the employees that are filtered out by the date join to data source B.

       

      For example, I have employees who have started 20 years ago, but the first date that is shown in my blended data view is from 2012 as that is where the data starts in data source B. How would I go about summing/counting all the employees who came before 2012, where data source B starts? I would then want to use this number and add to it for subsequent years.

       

      Thank you!