Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Instead of using the formula again in the Background, can you use the Column Name with ColorMix?
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,