Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Or This?
Chart1
Expr: = Sum({< YourListBox -= {'Product'} >} YourField)
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.
Hello Hina,
Try this.
This works!! Thanks Rohit and Vishwarath
In your Bar Graph properties add set analysis to ignore product field like :
Great. Can you close the thread marking correct/helpful responses.