Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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"