Pivot Table: Sum in Rows but fabs (absolut values) in the columns all

[#1]

Hallo,

I do have a pivot Table in QlikView like this (i just faked it in Excel for data privacy & for an easier understanding):

     => This should be the final result!

With one Fact (Expression) “CurrencyValue” and the Dimensions (Date, Name, Currency and Timeline (0-3m, 3-6M and 6-12m))

Now here is what I would like to have:

In the Red rectangle section:

            The sum() of all Elements from the timeline regarding the Currency.

In the green rectangle section:

            Just nulls. No Sum at all.

In the orange rectangle section:

            Here it comes. The added absolute values (sum(fabs()))  from all grey Elements in column D except the Currency ‘ZZZ’.

The last one is kind of tricky because I would like to have the sum() of the values of D.

Here is what I got so far:

(in the Expression Tab of the Pivot Table under Definition for the fact “CurrencyValue”)

if(Dimensionality() = 3, Sum(CurrencyValue),
if(SecondaryDimensionality() = 1, null(), sum(fabs(CurrencyValue) - if(Currency = 'ZZZ', fabs(CurrencyValue), 0)))
)

The problem is that I get following table:

     => I got so far.

The problem lies in the orange rectangle section. I just get sum(fabs()) from all values not just the values from the blue box.

Does anybody know how to solve this issue to get the a pivot table like the first above?

Any help is appreciated,

Markus