1 Reply Latest reply: Nov 13, 2012 7:36 AM by Yaseen Pullissery RSS

    Adding a dimension in a Expression

      Hi Guys,

       

      Ok so basically i have a Drill through bar graph it is grouped on g_Overall(Region,Branch,employee) Now i have the figures i need but i want to adda target which would be an expression something along the lines of

       

      ((SUM(TargetsPWD) * SUM(WorkingDays))*TotalEmployees)/COUNT(Dimension)

       

      basically on top level i want to see the target divided by how many Regions there is then when i click on a region ti should change to target divided by how many branches there are etc

       

      Is thsi possible ? any help would be greatly appreciated

       

      Regards

      Curt