Dear specialists,
Would you please take a look at my Qlikview Document.
I think my question is pretty clear when you see the pivot tabel but let me try to explain what I want.
My pivot table has one expression : Total (Sum(Amount))
The result can be (also depending on other selections) a positive or a negative number.
When the sum is larger then 0 I want it to show in one column, when it is negative it needs to be in the other column.
How do I get to sum them for the subtotals?
Thanks.
