paint values ​​that deviate from the average

[fabio182]

Hello everyone,
I have a pivoting table where two dimensions are presented (day and table) and a metric (average amount of data). It is possible to paint those cells that are below 20% of the average and above 20% of the average. Attachment. Thanks for your support

[petter · Accepted solution]

Maybe this:

If( Avg(ExtractRowCnt) / Avg(TOTAL <NOMBRE_TABLA> ExtractRowCnt) >= 1.2 OR Avg(ExtractRowCnt) / Avg(TOTAL <NOMBRE_TABLA> ExtractRowCnt) <=0.2, Green(50) )

[fabio182]

Thank you so much Petter.