4 Replies Latest reply: Oct 13, 2015 2:55 PM by Krishna Chaitanya RSS

    Adding Goal Lines

    Channing Dionisopoulos

      Hello all!

       

      I have attached my file.  I have made a scrap chart and I am trying to add a goal line to it. 

       

      The hierarchy of my data is as follows: Goal Group --> Goal Type --> Area --> Facility --> Department

       

      So for example, on line 218 below, Department 002 is in the Electrical Facility in the Assy Area with Scrap as the Goal Type and Area as the goal group. (The Goal Group's Area and the Field name Area are unrelated - confusing since they are named the same - see picture below)

       

      Whereas on line 198 below, Department 102 is in the 560XLS Facility in the Assy Area with Scrap as the Goal Type and Area as the goal group.


      Both rows have starting goals of 2220716 because that starting goal number is the goal for the Assy Area.  For facility, the 560XLS goal and Electrical goal should add up to get 2220716.  I won't look at goals for the department level.


      goalzzz.png


      Does anyone know how to do this?  I can't get it to work.  The granularity may be off and I'm not sure how to fix it.