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 

[lironbaram]

hi

you can try something like 

if (min(aggr(sum(Value),subproject,Project))<20,red())

[beck_bakytbek]

Hi Liron,

thanks a lot for your time and help,

what if, if my value within table are percent value like 20 %, i tried to impelement your solution, but it does not work,  am i missing something?

[sunny_talwar]

Would you be able to share a sample where we can see this laid out in a chart?

[beck_bakytbek]

Hi Sunny 

of Course , thanks a lot

[sunny_talwar]

In this example... I see one cell is highlighted (20%)... which might be the sub-project... how do I know what is the project it is associated with?

[beck_bakytbek]

Hi Sunny,

my Color Expression is false, i tried to make the Color Expression: if my Kriterien is under 40 %, then my total: Teilprozesse, Use Case should be red

[sunny_talwar]

What do you mean? Not sure I understand

[beck_bakytbek]

i mean:

if my Dim: Kriterien under 40 % , then my TotalDim: Teilprozesse and Use Case should be red

[sunny_talwar]

Isn't it doing that already?