Conditional Layout on a Chart

[#1]

Here is what my application shows:

ListBox one contains all the products we have. (Product1,Product2,Product3,etc)

ListBox two contains all the industries we serve. (Industry1, Industry2, Industry3, etc)

1. The first requirement is to have a chart like the one below which I have completed:

AcctNumber          OrganizationName               ProductName            

123                         Balls Store                              Product1

123                         Balls Store                              Product2

234                         Pales Store                             Product1

345                         Young Store                            Product1

345                         Young Store                            Product2

456                         Hall Store                                Product1

2.  The second requirement is to show the following:

AcctNumber          OrganizationName               ProductName            

234                         Pales Store                             Product1

456                         Hall Store                                Product1

The second chart are those Organizations that own Product 1 and not Product 2.  Now we can determine that from the first chart but have to send it to excel and filter items out.  What I was hoping is either put a Condition on the Layout of the chart or just highlight those Organizations in the first chart.  Is this possible and if so please assist. 

David

[#2]

Hi David, if you add the Product List box to the Layout and if you select Product1 in the LB, the first chart automatically show Product1 list only. I don't think so you dont need another object.

[nagaiank]

Did you try using And-Mode listbox?

An example is attached.

[renuka_sasikumar]

While creating chart you can also give the if condition in the Dimension such as selecting only

ProductName as Product1

[#5]

I have not tried the and mode listbox.  I like the ldea but the problem is it gives me all of those clients with Product 1.  I only want those clients that own Product 1 and not Product 2.

David