coloring of total depending on subtotal

[beck_bakytbek]

Hi Folks,

i got a Question, my data-structure does look like:

Project	Value
A	100
B	80
Subproject
A1	80
A2	20
B1	50
B2	30

my Question is: as you see my Subtotal of subprojectA2 is 20 and Project A is 100

how can i make the following Color Expression: if my Subtotal of Subproject is 20, so then Total of my Project should be red ?

does anybody have any idea?

Thanks a lot 

[beck_bakytbek]

NO, if you see the Dim: Sortiment and Dim: 'Pflege Strategisches Produkt und Serviceangebot', there i have values with 36 %

[sunny_talwar · Accepted solution]

You want something like this?

[beck_bakytbek]

Dear Sunny,

again you saved my day, thanks a lot for time and help. it does look great 😃