Need help in Correcting the expression

[kunkumnaveen]

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  . 

Thanks

[sunny_talwar]

Would you be able to share a sample to take a look at this

[kunkumnaveen]

Hello Sunny,

Please find the attachment ..

In pivot  Table 

Dimensions:

1)Category 

2)Brand

Expression

Sum(Volume)

Now Color top 5 Volumes Cells ...Category Wise in green color

The Cell Color of Category should remain Green  even though if we expand the group dimension (Brand )

which i am not able to get

[kunkumnaveen]

Hello Sunny,

Please find the attachment ..

In pivot  Table 

Dimensions:

1)Category 

2)Brand

Expression

Sum(Volume)

Now Color top 5 Volumes Cells ...Category Wise in green color

The Cell Color of Category should remain Green  even though if we expand the group dimension (Brand )

which i am not able to get