Pivot / Subtotal Som / Dimensionality / AGGR() Question

[Anonymous]

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.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[Anonymous]

Thanks Gysbert, Seems to work great!