Pivot Table Background Color by measure

[fatihtomruk]

Hi all.

I have pivot table like below.  I want to color background min and max number by month(Ay) or  like picture right. 

I used  formula like this.  =colormix1(sum(Sales)/Max(TOTAL aggr( Sum(Sales),Month,CategoryName)),yellow(),lightred())

But my pivot tables formula very long as below.  so could you plase help me. 

my pivot table formula:  

if([Net/Brut]='NET', sum(if(month(Veri_Kesit_Tarihi) = Month(Today()) and ([Ürün Durumu]='paymentrequired' or [Ürün Durumu]='continue')
,[Finans Tutarı])),
sum(if(month(Veri_Kesit_Tarihi) = Month([Proje Gerçekleşme Tarihi]) and ([Ürün Durumu]='paymentrequired' or [Ürün Durumu]='continue')
,[Finans Tutarı])))/1000

Thank you.

My Pivot Table: 

[Saravanan_Desingh]

Instead of using the formula again in the Background, can you use the Column Name with ColorMix?

[ArnadoSandoval]

Hi @fatihtomruk 

This is a long reply I gave to some member in the community a couple of months ago:  Conditional colour formatting calculated measure/attribute ; you will find helpful information that could assist you resolving your issue, please let me know if you need guidance!

Regards,