Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Have you tried:
Sum(EqAmount) + Sum(LoanAmount)
In your Total column?
how do you distinguish between what is Company 1 & what is Company 2
You don't have to because they are dimensions (if they are), your table will distinguish it by itself
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)