Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have to get done Cell colored in green for top 5 percentage values
Expression:
if(Dimensionality()=1 ,
if(rank(sum({<Year={$(vMaxCY)}>}Volume)
/
(sum({<Year={$(vPreCY)}>}Volume))-1)<=5,green(),rgb(201, 219, 189)
),rgb(201, 219, 189) )
Expression is Working Fine
But when i tried to expand any value the color getting disappear
So what correction should i need to do in my expression so that the color of Dimensionality 1 should remain green (861.08,49.08,34.52,14.55,9.73),even though the values are expanded .
Super Tim , it Worked Thanks , but to get colored Top 5 cells ,i need to set as <=6, if i set <=5 then only 4 cell r getting green colored.
Super Tim , it Worked Thanks , but to get colored Top 5 cells ,i need to set as <=6, if i set <=5 then only 4 cell r getting green colored.