You just need to define Relationship between 2 data sets and can achieve what you are looking to do. Please find example attached to this response.
Your calculation should be as following for % Attainment:
If you find this helpful - please mark it so others can benefit from it. Thank you.
Blending Data.twbx 11.2 KB
Hi Ankit -- Thanks for the reply. In my dataset, Leads and Opportunities are their own columns and are not under a 'Type' column like you showed. I guess the answer is to pivot the data? Was trying to avoid this but I guess I'll have to
1 of 1 people found this helpful
Hi Peter - Yes, you will have to Pivot the data - there is no other way to break it apart if all 4 measures are listed separately.