Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Let us say that the expression for column1 is
=sum(Value)
the expression for Column2 would be
=sum(Value)/sum(total Value)
You may want to search the QV help for the topic "Sum of Rows in pivot tables"