Qlik Sense Pivot Table Totals

[jjking58]

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,

[vmoreno2605]

Have you tried:

Sum(EqAmount) + Sum(LoanAmount)

In your Total column?

[jjking58]

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

[vmoreno2605]

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

[Marcos_rv]

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)