Pie Chart Help

[joshrussin]

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