2 Replies Latest reply: Feb 9, 2016 3:17 PM by David Funk RSS

    Through Time Comparison Counter

    David Funk

      I am trying to work on a set analysis that counts the number of Employees who had a decreased number in sales from the previous quarter but I am having trouble figuring out how to go about doing this.

       

      So far I have:

       

      sum({$<[Pd_End_Dt]={"*"},Employee_Name={"*"}>}[Sales])-above(sum({$<[Pd_End_Dt]={"*"},Employee_Name={"*"}>}[Sales]))

       

      but am unable to get past this. I've tried the count function but can't seem to get it to work. Ultimately I would like to be able to drill down from Company>Department>Employee but for right now just need the number of employees that decreased.

       

       

      The table looks something like this:

       

         

      Pd_End_DtEmployee_NameSales
      3/31/2015A300
      6/30/2015A350
      9/30/2015A200
      3/31/2015B150
      6/30/2015B200
      9/30/2015B200
      3/31/2015C500
      6/30/2015C400
      9/30/2015C300

       

       

      Any help would be appreciated, thank you!