I have a requirement. Can we have multiple expression on a chart. I know we can create a line table and use conditional show/hide in expressions, but my requirement is user wants to select more than one expressions.
for e.g: I have a line chart. my Dimension is Month and i have these expressions
Now, the user wants to select any one expression at a time or all expressions at a time from a single list box.
Here is the chart that I have. Here I have Revenue and Volume which are always static. Above this chart is a list box which has multiple values (I used line table to create these). From this list box I can select only one value at a time and the chart will add one more line. But i would like to have the ability to select two or more values at a time. then there will be multiple lines in chart depending on the how many selections I did.
jerem, i always wondered if your method is better than the simple "like" comparison that i have been using now? i would like to use the method you suggested if it is better than the one i use performance wise.