Dimension limits on charts

[suryaa30]

Hi In below case I have two dimensions and 3 expressions

When I select Dimension 1 there is multiple values for  Dimension 2

I have to limit values of the Dimension 2 to only those having 80% contribution based on one of the expression.

The dimension limit works for straight table but not the chart shown. what is the possible reason?

[ramasaisaksoft]

Hi Surya,

What is your expected output in that Straight table

K7 is having 7 values ,so what is your expected output?

if possible attache the sample .qvw file with sample data.So that our folks will help to you ASAP.

[suryaa30]

The values in the straight table are correct.When K7 has been selected it should show only Retainers contributing to 80%.

But in the bubble chart I see additional retainers apart from the ones needed

[avinashelite]

Try like this , calculate the 80% in your expression andd then

if(Expression >80 , Expression )