0 Replies Latest reply: Mar 9, 2012 10:25 AM by GIANNI RATTI RSS

    Incidence in Pivot table

      Hi,

      in a pivot table I have to divide all the possible values (val2) of a dimension (dim1) by the same amount (tot1, Header4) that is the total of the other possible values (val1) of the same dimension in order to obtain the incidence on the total (total1).

       

      Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9Header 10
      dim1val1val1tot1val2val2tot2incidincid

      dim2

      2030

      50

      15

      355015/5035/50
      dim210152510253510/2525/25
      tot30457525608525/7560/75

       

      the possible values are defined as Sum(field)

       

       

      In attached xls: blue columns are the "incidence"... yellow column is the total (denominator) and orange ones the numerator.

       

       

      Thanks

      EP

      How can I do?