Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

2 Replies
erichshiino
Partner - Master
Partner - Master

Let us say that the expression for column1 is

=sum(Value)

the expression for Column2 would be

=sum(Value)/sum(total Value)

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You may want to search the QV help for the topic "Sum of Rows in pivot tables"