6 Replies Latest reply: Dec 9, 2011 9:00 AM by sabarish RSS

    calculate summary on change of a dimension

      Hi,

       

      How can we do a sum on change of a dimension?

       

      for eg

       

      Calculate the salary received till today on change of employee name which is a dimension?

       

       

      Emp NameDeptSalary
      TomFinance1000
      EvanAccounts2000






       

       

       

      What happens now is it calculates sum of all the salaries.I need the sum for each employee or when Emp Name changes?

       

      How to achive that

       

      Regards,

      Sab