I have to calculate KPI on both Submitter and Recipient separately. Employee ID and Submitter Id and Recipient ID will have similar values.
Table1 is like total headcount data. And Table 2 is like part of people involve from that data.
i want to join both tables. But if i join with Employee ID from table 1 and Recipient ID then data will come wrong for Submitter KPI and if i join Employee ID and Submitter ID then Recipient data will come wrong. As one submitter can give value to more than one Recipient.
Someone suggested me to use flags. But I am not sure how to use. Please suggest.