topic Re: Total Row with Difference between 2 Totals in QlikView

Total Row with Difference between 2 Totals

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a Pivot Table like this:

What I need is to add a Total row with the result of INCOME - EXPENSES:

Is there any way to do that?

Thank you!!!

MK9885 — Thu, 19 Oct 2017 18:52:58 GMT

What is your expression?

You want to add Total 900 with 1500 and 600?

lorenzoconforti — Thu, 19 Oct 2017 20:28:08 GMT

In your expression for AMOUNT, write something along these lines:

=if(Dimensionality()=0,Sum({<ACCOUNT={"INCOME"}>}AMOUNT) - Sum({<ACCOUNT={"EXPENSES"}>}AMOUNT), Sum(AMOUNT))