Max(Rank()) issue in pivot table

[#1]

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.

[SunilChauhan]

if(Max(Rank())=5,RED(),Green())

write color function for color needed in place of red and green

hope this helps

[#3]

Hi,

I dont know the eaxct max value with which i can compare...is there a way i can extract Max(Rank()) dynamically??