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.
Have a look at the following Design Blog post, may give you an option on how to approach things for your use case, I am also including the base link after that to the are in case you wish to further search for other posts, there are over 700 in this area, mostly how-to related...
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.