2 Replies Latest reply on May 11, 2013 12:01 AM by Antonio Willybiro

    how do i create a calculated group?

    Antonio Willybiro

      Hi I have a dimension called 'account name'.

      within this dimension I have several values, like revenue, staff costs, other costs, g&a etc...

      I want to create a new dimension element that would be called '% margin' for instance. for instance it would equal "other costs/revenue"

      I then want to display sum value of the measure like that

       

      Revenue

      staff costs

      other costs...

      % margin

      ...

      g&a

      ...

       

      any idea how I can create that additional line item?

       

      thanks

      Antonio