Applying default only to a specific element in a chart

[#1]

Hello All,

I have got a sheet with a Line Graphs( 3 years of trend data) and a few Pie charts. I want my Pie chart to default to FY14 but the

line graph should show 3 trend lines. Please note there are other selection list boxes which can change both the line and Pie charts.

  The problem I face is when I give a default I see a single trendline and Pies appear correct. I tried disassociating the file from the Line chart but then the functionality of the other list boxes is lost.

Appreciate any help or suggestion on this.

Vimal

[#2]

Hi Govindan, You have to use set analysis in the expressions.

In your pie chart simply say Sum({<year_code={'FY14'}>}sales)

In your line chart say Sum({<year_code=,>} sales)

That should do the trick.

Thanks,

Ram

[Anonymous]

Can You provide a sample app,

it would be easy to understand the issue.

Anyway you can use different expression in pie chart with set analysis for

Year={FY2014}