I need to create two charts that display year to date sales by store name
the user wants to see the YTD sales for store1 in one chart and the YTD sales for store2 in the second chart
however the store1 and store2 are to be selected from 2 list boxes without affecting the whole selection on the document!!
the 2 list boxes should read store names from the table of stores
is there a way to read store names and save them in 2 arrays ? and then the user selects these stores from the arrays so that in the dimension of the chart the expression is grouped by the selected store?
