6 Replies Latest reply: Mar 7, 2017 10:52 AM by John Mårtensson RSS

    Discard fields table calculation?

    John Mårtensson

      Hi,

      I'm a newbie in this world so please be patient.

       

      This is the table object I have:

       

      EmployeeTeamYesterdayYesterday Department
      Jane DoeTeam A=(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))[X]
      John DoeTeam B
      =(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))
      [X]

       

      I also have a flag for the department.

       

      What I want is to make the same calculation but on the Department flag. I've looked in to the Aggr-function but didn't make it. Someone that has any suggestions?

       

      /John