Pivot Table - External Data with Parameters

  • Thread starter Thread starter Tommy
  • Start date Start date
T

Tommy

Dear All

I built a pivot table by getting the data from an external datasource. It
works fin all the time but now I want to add a parameter to the source so
that everytime when I placed the parameter and click refresh. The pivot
table will give the result according to the parameter.

Do you have any idea on it?

Thank you very much!!

Regards,
 
Hi,

You could put the Parameter field into the Page area and then pick the
parameter there. However, if you code the data retrevial you can input a
parameter into the SQL statement.

So if the first one doesn't work record a macro that creates the connection
& pivot table and post the code as a separate question and we should be able
to show you have to modify.
 
Back
Top