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.

       

      piechart.PNG

      piechart1.PNG

      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