Solved

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

Posted on 2011-09-03
2
521 Views
Last Modified: 2012-05-12

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
Comment
Question by:ezkhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:ezkhan
ID: 36480008
Any Comments Please!!!!!
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
ID: 36480618
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question