# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for
Did you mean:
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

4 Replies
Creator

Have you tried:

Sum(EqAmount) + Sum(LoanAmount)

In your Total column?

Contributor III
Author

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

Creator

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

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)

Tags
Community Browser