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