1 Reply Latest reply on Jun 13, 2016 9:30 AM by Tom W

    help in multidimensional relationship

    Jaymin Panchal

      I need to build three dashboard as below. please advise how to achieve that by using multidimensional relationship. 

       

      1) should display all the records

      2) Includes Emp Ids that have at least one IT as Department

      3) Includes Emp Ids that do not have at least one IT as Department

       

       

      Emp IdID
      DepartmentDepartment Id
      230100IT

      5

      101IT7
      102IT8
      103IT9
      104IT11
      231105HR100
      106HR13
      107HR16
      108HR19
      109IT20
      110IT22
      111IT54
      112HR32
      113HR28
      114HR79
      115HR83
      232116HR91
      117HR90
      118HR23
      119HR21