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 Id | ID | Department | Department Id |
---|---|---|---|
230 | 100 | IT | 5 |
101 | IT | 7 | |
102 | IT | 8 | |
103 | IT | 9 | |
104 | IT | 11 | |
231 | 105 | HR | 100 |
106 | HR | 13 | |
107 | HR | 16 | |
108 | HR | 19 | |
109 | IT | 20 | |
110 | IT | 22 | |
111 | IT | 54 | |
112 | HR | 32 | |
113 | HR | 28 | |
114 | HR | 79 | |
115 | HR | 83 | |
232 | 116 | HR | 91 |
117 | HR | 90 | |
118 | HR | 23 | |
119 | HR | 21 |
You could create a calculated field like "HasITDepartment?" as COUNT(IF Department = 'IT' END) > 0