Could anyone who has finished the exam show me the formula for question 6? I failed 2 questions for this part.
I think I just need to refer the relevant numbers from another module and apply selections, and then it could be done. However, my way didn't work.
Here's my formulas. Thanks very much!
Hi, you will need to use lookup function as the answer requires both region and role.
Also another hint. You're very, very close.
Use the SUM function on Region and Role from your SYS08 module.
You got this!