Selection in Line chart

[#1]

I have a two fields named bibserial and saleno where

bibserial saleno

1 14

2 15

3 16

4 17

.... .......

38 52

Now i have created Avg Price and a Tasting graph in Line chart with dimension saleno and for Avg Price The expression is avg(if(Price>0,NETAMT/SOLDWT)) and for Tasting Point the expression is (Avg (If(Leaf>0,Leaf)) + avg (If(Liquor>0,Liquor)) +avg (If(Infusion>0,Infusion)))/3. Now I have a selection box with Saleno, Garden,Centre and Financial Year.When i choose a particular saleno with Particular Garden, centre and Financial Year the chart shows only in dot for that particular saleno but i want to see all the Avg Price and Tasting point starting from saleno 14 upto the selected saleno say if i select saleno 28 it will show in line chart from saleno 14 to saleno 28.

[tresesco]

Hi,

Create a variable, MaxSale=max(saleno). Now use calculated dimension as : IF (saleno>=14 and saleno<=$(MaxSale), saleno).

hope this would help you.

regards, tresesco

[#3]

It does not works