How to pass parameter dynamically?

Question

Hi,

I am using Powerpivot 2010 , a feature in Excel. I am getting a source from SQL query where i am using two parameters in that. I would like to pass the parameter in the Powerpivot table and chart dynamically. say for example i have a monthly table contains some data for that particular month. If i have a parameter say month in the query, I would like to pass that in the Powerpivot table dynamically like how we do in SSRS. Can some one help me in this regard.  Thanks!

Answer 1

You can create a parameterized query using an Excel worksheet cell as in

Query 4 -- A parameterized query to list of customers in a zip code that is specified dynamically

http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/build_query_4.html

I don't know if you can use a PowerPivot grid cell in place of the worksheet cell.

Answer 2

Did it work?

Answer 3

Thanks for your reply, I ll try this option and let you know whether it works for me..