How to change pie chart series (columns) based on the parameter selection from one column to another.
Posted on 2011-09-03
I have a situation where i need to switch pie chart from one column of dataset to another based on the selection made from dropdown list of parameter values.
e.g., I have three columns dataset Column1, Column2 and Column3 all are listed in dropdown of a parameter i.e., par1. When I make a selection from dropdown from column1 to column2 the pie chart should change to column2 values.
I have tried to achive this by setting visibility property of the series of column1,2 and 3 using expression to true and false based on parameter selection but, it did not work.
Your help and advice will be greatly appreciated.