currently i am facing some challenges in the implementing the global target calculation with the dynamic changing resource column. Please find the attached excel for the same.
where i need to calculate the weight of the resource as well as Global Target column.
Weight=count(distinct Resources)/count(Total distinct Resources)-- I am getting the weight of the resource across the Market
When iam multiplying this with the target and for the global
SumProduct of Target across the each
Global---sum(Target*Weight)/Sum(Weight)
where i will get the global target.
I have attached the sample data
where Resource--Tab1 and Target which i have given in the excel
