I have a trend chart which shows product share over the last 12 months. The formula used is :
sum({<Product_ID={1}>}Volume)/ sum({<Product_ID={10,11}>} Volume) . That is Product Volume/Market Volume. Market Volume is sum of volumes of products 10 and 11.
There is a list box to select the product. However when I select a product in the list box, the legend also shows products 10 and 11 in the legend,as they are part of the expression. I only want to see Product 1 in the legend. Please help.