2 Replies Latest reply: Apr 17, 2011 2:10 AM by Rob Wunderlich RSS

    How to get sum of rows of pivot in a single value

      I have pivot table like this

       

      Centers Column1 Column2

      A 2 2/6=0.33%

      B 1 1/6=0.16%

      C 3 3/6=0.5%

       

      Sum of Column here is with rows values are

      2+1+3=6

      I want to divide this sum value with single cell value of Centers column in suppose Column2

      how can i get it please tell this, i able to get the value of Column(1) but not the sum values of all rows