2 Replies Latest reply on Feb 11, 2013 6:44 AM by Kevin Sullivan

    Calculating specific dimension Categories

    Kevin Sullivan

      In the attached I want to calculate the Waterfall Categories dimension so that it creates a new row called Total Transfers.  So the calc would work like this:

       

      Headcoun - (Previous Headcount + Lateral Movement Out of Organization + Lateral Movement Into Organization + Vertical Movement Out of Organization + Vertical Movement Into Organization + Termination + New Hire) = Total Transfers

       

      The new row in the table Total Trasfers would equal -13 in this example

       

      Waterfall CategoriesSeptember
      Headcount2614
      New Hire44
      Termination-28
      Vertical Movement Into Organization11
      Vertical Movement Within Organization50
      Vertical Movement Out of Organization-4
      Lateral Movement Into Organization17
      Lateral Movement Within Organization4
      Lateral Movement Out of Organization-10
      Previous Headcount2597