Pivot Table - External Data with Parameters

[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,

 

[Shane Devenshire]

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.