Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jjking58
Contributor III
Contributor III

Qlik Sense Pivot Table Totals

I would like to total multiple columns under a dimension and would like to know if it's possible how to do it.

Example: Company 1 total should only include  EqAmount & LoanAmount for Company 1,

                    Company 2 total should only include EqAmount & LoanAmount for Company 2

Thanks in advance,

Pivot.png

4 Replies
vmoreno2605
Creator
Creator

Have you tried:

Sum(EqAmount) + Sum(LoanAmount)

 

In your Total column?

jjking58
Contributor III
Contributor III
Author

how do you distinguish between what is Company 1  & what is Company 2 

vmoreno2605
Creator
Creator

You don't have to because they are dimensions (if they are), your table will distinguish it by itself

Marcos_rv
Creator II
Creator II

try this 
company 1
Sum({< CompanyDesc ={'Campany 1'} >} EqAmount) + Sum({< CompanyDesc ={'Campany 1'} >}LoanAmount)

company 2
Sum({< CompanyDesc ={'Campany 2'} >} EqAmount) + Sum({< CompanyDesc ={'Campany 2'} >}LoanAmount)