8 Replies Latest reply: Jan 20, 2014 3:19 PM by Nicole Smith RSS

    Analysis based on Dept and Individual

      How can i show a chart which displays the values based on a individual and also the department.

       

      Ex - Input dataset

        

      emp_iddept_idvalues
      1d12
      2d13
      3d25
      4d24
      5d28

       

      Needs to show a chart by comparing the individual values vs the Dept Total values

      emp_iddept_idvaluesSumDeptToal
      1d125
      2d135
      3d2517
      4d2417
      5d2817

       

      The Dept is just one dimension, there are other dimensions like Month, Year which comes in to account when they select an individual.

      Calculating these values at the table level is not possible.

       

      Could be a simple thing but i think i am missing some thing, i tried the Set Analysis as below but didn't work

       

      sum ({1<EMP_id={"*"}>}values)

      Any ideas would be greatly appriciated .

       

      Thanks,

      Rajesh