enabling/disabling expressions based on selections
hi guys, let's say i have a bar chart and a list box with sales, costs and netrevenue as its selections
the chart shows sales, costs and netrevenue as its expressions with location as the dimension
by default all 3 bars will be shown. whenever i select only sales from the list box, only the sales bar will be enabled and the rest disabled and whenever i select sales and costs, only the sales bar and costs bar will appear...
through some searching, it seems that i can do some coding/macro to enable/disable the expressions based on the list box's selection