13 Replies Latest reply on Jun 7, 2016 8:23 AM by Kevin MONGES

    LOD Hierarchy : Trying to keep the high level of agregation

    Kevin MONGES

      Hi Guys,

       

       

      My problem should be easy but I can't resolve that.

      YEAR MONTH and WEEKDAY are gathered by a Hierarchy (I created the fields)

       

       

      What I WANT : I would like to :

      keep the value of 2016 at "255" in the "ValueA" field,

      Keep  the value "105" for "june"

      Keep the value "5" for "S24"

      When I drill down, the value decrease too and I don't want this.

       

       

      I was thinking about doing a LOD expression like this :

      { FIXED [Year], [Month], [Weekday] : SUM([ValueA]) }

      But this doesn't work....

       

      Thank you for your help

       

      Kevin