4 Replies Latest reply: Jan 18, 2013 4:53 AM by Nicolas Aimain RSS

    sum disregarding dimension but not selection

    Nicolas Aimain

      Dear all,

       

      I'm trying to calculate a value along a hierarchy

      I have 2 fields: Site and Division and a Value

      >> this value is filled only at the Business Unit level and on an empty Site (or a dummy Site if it should help)

       

      I'm trying to display this value for all site linked to the Business Unit without displaying Business Unit in my straight table

       

      For example

       

       

      Site

      Business Unit

      (not shown in the table)

      Value

      Display value

      (awaited result)


      A120120
      Site AA-120
      Site BA-120

      B9090
      Site CB-90
      Site DB-90

       

      i tried several expression combinating TOTAL and set analysis but without success and i didn't manage to find an example that fit with my needsq

      sum(TOTAL <Site> Value)

      sum({$<Site=,[Business Unit]=P([Business Unit])>} Value)

       

      does anybody has an idea ?

       

      Thanks in advance