Color coding in Pivot table: Multiple dimensions

[mthsbr92]

Dear Community,

I have the below Pivot table which summarizes financial data (Sales, Target Sales etc.) across three dimensions.

Across all 3 dimensions, I'd like to mark totals and sub-totals in red and green, respectively, depending on their sign. To do so - for column "deviation vs. TGT" - I have used the simple Color expression: =if(JanActuals-JanTGT>0,Green(),Red())

In my table, however, I see many positive values marked red and many negative values marked green. I cannot really identify a pattern but it seems that Qlik colors a total in red as soon as a single related sub-total is negative. 

How can I change the coloring logic so that any value is marked red/green according to its sign? 

Thanks and best regards,

Matthias

[mthsbr92]

Hey there,

would really appreciate if somebody could help me here. Was hoping it would be an easy thing for "pros" 🙂

Best,

Matthias