4 Replies Latest reply: Jan 13, 2010 5:17 PM by Jean-Jacques Jesua RSS

    Double aggregation

    Jean-Jacques Jesua

      Hi,

      I can't solve this problem.I have a table with 3 dimensions (A, B, C) and one numeric value (H)

      I want to create a chart with

      One Dimension : A
      One Expression :

      The sum of H, calculated only for one value of B corresponding of the maximum of H for each C including in B

      To calculate the Max for each B, i tried Max( Aggr( Sum(H) , B , C) ) => OK

      But sum( Max( Aggr( Sum(H) , B , C) ) ) is not correct. I don't understand why ?

      Maybe some help is welcome.

      Regards

      Jean-Jacques