2 Replies Latest reply: May 8, 2013 3:52 AM by Jairo Martín Miguel RSS

    Acumulative Expresion

      Hi,

       

      I have this entry data

       

      MonthDataTypeValue1Value2
      01R101
      01O121
      02R111
      02O152

       

      and I would like to obtain this result

       

      Month0201
      DataTypeRORO
      Value121271012
      Value22311

       

      where the rows Value1 and Value2 are acumulative expresions

       

      Value1 = sum(Value1) = Value1 of Month 01 + Value1 of Month 02

      Value2 = sum(Value2) = Value2 of Month 01 + Value2 of Month 02

       

      I have tried doing this using an expression like  RangeSum(below(sum(Value1), 0, NoOfRows())), but there is a problem with the dimension DataType.

       

      so actually the result obtained is this

       

      Month0201
      DataTypeRORO
      Value111151012
      Value21211

       

      Any suggestions?