2 Replies Latest reply: Apr 26, 2013 7:35 AM by Jairo Martín Miguel RSS

    Pivot Table

      Hi,

       

      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
      DataType RORO
      Value14811151012
      Value251211

       

      Any suggestions?