Colored field bar by Sub-field values

[Amit_B]

Hi,

I would appreciate help with the following topic:

Let take an example of a bar chart that contains a hierarchical dimension (drill down) of Type and SubType, and their Profit for a specific period.

The easy part - color the bars in Red where the profit in negative.
The complicated part - when displaying the profit by Type, bars should be colored Yellow if their overall profit in positive, but at least one of their subtypes has negative profit.

In the picture, Type D will be colored red and Type B will be colored yellow (because SubType b20).

I need to use it also in tables and pivots.

Thanks.

[Clement15 · Accepted solution]

Hello,

I used test data so it will have to be adapted, but here is what I got.
I don't know if it is the most optimized though.

[Amit_B]

I just needed to write 'Sum(value) < 0' but it works!
Thank you very much!