Discussion Board for collaboration on QlikView Layout & Visualizations.
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
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
the expression for Column2 would be
You may want to search the QV help for the topic "Sum of Rows in pivot tables"