4 Replies Latest reply: Apr 29, 2013 11:15 AM by Jairo Martín Miguel RSS

    Pivot table, with calculated column

      Hi,

       

      This is an actualization of a previous post, Thanks to Gysbert Wassenaar to solve one of my problems.

       

      I have this entry data

       

      MonthDataTypeValue1Value2
      01R101
      01O121
      02R111
      02O152

       

      and I would like to obtain this result

       

      MonthTotal0201
      DataTypeRO%RO%RO%
      Value1212777,78%111573,33%101283,33%
      Value22366,67%1250,00%11100,00%

       

      where the rows Value1 and Value2 are expresions and the colum % is an aditional value of the dimension DataType

       

      Value1 = sum(Value1)                    in % column sum({<DataType={'R'}>} Value1) / sum({<DataType={'O'}>} Value1)

      Value2 = sum(Value2)                    in % column sum({<DataType={'R'}>} Value2) / sum({<DataType={'O'}>} Value2)

       

      but the result obtained is this

       

      MonthTotal0201
      DataTypeRORORO
      Value1212711151012
      Value2231211

       

      Any suggestions?