Highlight max and min values in pivot table

[paolojolly]

Hi, I need help to correct highlight max and min values in pivot table

In attached document i use in background color setting

if(isnull(sum(W_TOT_KG)) <> -1,
  if(sum(W_TOT_KG) = Max(total aggr(sum(W_TOT_KG), MESE_DOC, ANNO_DOC)), rgb(0,255,0),
If(IsNull(sum(W_TOT_KG) ) <> -1 and sum(W_TOT_KG) <> 0,
If(sum(W_TOT_KG) = Min(total aggr(
If(ISNULL(sum(W_TOT_KG)) <> -1 AND sum(W_TOT_KG) <> 0,
sum(W_TOT_KG)
)
,MESE_DOC, ANNO_DOC)), rgb(255,0,0)) 
)
)
)

but it does not always work

Can someone help me?

Thank you very much

[antoniotiman]

Yes is correct. You need to exclud Month 0 Value

See Attachment

[paolojolly]

Thank you. your work is useful but I do not understand why, if I have only one filter I get a result like the following

with cells of future month with value zero colored in red(not correct) and when i select another filter result become correct

thank you again

[paolojolly]

Attached file reproduce the problem

thank you

[paolojolly]

Attached file reproduce the problem

thank you

[antoniotiman · Accepted solution]

Try

If(Sum(W_TOT_KG)=Min({<MESE_DOC={"=Sum(W_TOT_KG) > 0"}>} TOTAL Aggr(Sum(W_TOT_KG),ANNO_DOC,MESE_DOC)),Red(),If(Sum(W_TOT_KG)=Max(TOTAL Aggr(Sum(W_TOT_KG),ANNO_DOC,MESE_DOC)),Green()))

[paolojolly]

thank you.

I have another problem.if you look at the attached file , if I do not have any active filter this solution does not show correctly the max value

thanks

[sunny_talwar]

Can you check this expression:

If(Sum(W_TOT_KG)=Min(TOTAL Aggr(If(Sum(W_TOT_KG) > 0, Sum(W_TOT_KG)),ANNO_DOC,MESE_DOC)),Red(),

If(Sum(W_TOT_KG)=Max(TOTAL Aggr(Sum(W_TOT_KG),ANNO_DOC,MESE_DOC)),Green()))

[paolojolly]

Thanks also this solution works properly

Regards,

Paolo

[paolojolly]

Thanks this solution works properly

Regards,

Paolo

[sunny_talwar]

We are glad you finally found what you were looking for .

Best,

Sunny