Alright, not sure how to do this or if it's even possible, but thought I'd have to ask.
I am trying to make a pie chart that shows the MTD processed per employee by area.
Here are two different files.
In Program_Dash, there is a field called Distribution.
In Area_EMP, there are fields called MMO Distribution, Bioventus Distribution, and ZB Distribution.
Is there any way to make these 3 in Area_EMP equal to just Distribution in Program_Dash?
I want the Dimension of the pie chart to be Program_Dash,
the formula should be:
Sum(Processed_Dash) / Sum(Actual_Emp)
while month and year = this month