0 Replies Latest reply: Jul 24, 2017 2:28 PM by Joshua Russin RSS

    Pie Chart Help

    Joshua Russin

      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