List Box and Charts

[#1]

Hi

I have a list lox which has three values, let's assume 'Country', 'Sale amount' and 'Product' also have 3 charts C1, C2 and C3. What I am trying to do is when I select 'Product' nothing should happen in chart C1 but in C2 and C3. Can anyone please help how can I achieve this.

[vishsaggi]

In your chart expression use set analysis like:

Chart1

Expr: = Sum({< Product = >} YourField)

Do this for all the 3 charts. If this is not what you looking for can you share your expr or a sample to work on.

[vishsaggi]

Or This?

Chart1

Expr: = Sum({< YourListBox -= {'Product'} >} YourField)

[#4]

Thanks Vishwarath. I am new in working on charts, just to elaborate more, I have attached a sample wherein I need.. if any of the list item is selected from Product list should not affect bar chart but only show the changes in pie chart.

Let me know if this is clear.

[rohitraut]

Hello Hina,

Try this.

[#6]

This works!! Thanks Rohit and Vishwarath

[vishsaggi]

In your Bar Graph properties add set analysis to ignore product field like :

[vishsaggi]

Great. Can you close the thread marking correct/helpful responses.