So, here's my issue. I'm trying to show the number of items sold by each product. I'm using a stacked bar chart which shows bars by month and stacked by product (only a few so the bars are ok). Now, In the Caption i want to mention the top 2 products sold. How can I do that without filtering out the bar chart? Even if I try to make a copy of the dimension, when I go to filter it, it filters out the main chart.
Mike, take a look at the end of this thread - it talks about how to use "Sets" to accomplish the same sort of task you need to get done. It's not an exact fit, but close enough to push you in the right direction.