• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

How to change pie chart series (columns) based on the parameter selection from one column to another.


Hi,

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.

Many thanks.
0
ezkhan
Asked:
ezkhan
1 Solution
 
ezkhanAuthor Commented:
Any Comments Please!!!!!
0
 
Nico BontenbalCommented:
You could use an expression for the data series that goes something like this:
=iif(par1="Col1",Col1,iif(par1="Col2",Col2,Col3))
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now