Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to conditional formatting for top 5 values in each calculated column.
I'm using background color expression if(rank(sum([Roadway Clearance Time])) <= 5 ,RGB(183,255,255)) but not giving correct output.
Can any one suggest? I have attached table here.
@dhruvipanchal88 Could you please use the below expression,
if(Aggr(rank(RoadwayClearanceTime),MaintenanceShed)<=5,RGB(183,255,255))
If this resolves your issue, please like and accept it as a solution.
@dhruvipanchal88 Could you please use the below expression,
if(Aggr(rank(RoadwayClearanceTime),MaintenanceShed)<=5,RGB(183,255,255))
If this resolves your issue, please like and accept it as a solution.
It worked. Thank You @Sidhi91