Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table with it's dimensions as hierarchy of employees and in the expression part i want to give a rank function.
I want to give a different color to Max(Rank())) , I.E 1,2,3,4,5 are the ranks that the cell with rank as 5 should have a different color from the rest.
Thanks for any kind of help
Utsav.
if(Max(Rank())=5,RED(),Green())
write color function for color needed in place of red and green
hope this helps
Hi,
I dont know the eaxct max value with which i can compare...is there a way i can extract Max(Rank()) dynamically??