DYNAMICALLY data source for pivot table
Thanks Tom, situation here is, my datasource is three different SQL Server
(analysis server (AS2000)) popluating data from cubes.
Help please
Thanks
kalyan
"Tom Ogilvy" wrote:
make the datasource for your pivot table a defined name such as Database.
then just have each button redefine the range Database refers to and then
refresh the pivot table.
--
Regards,
Tom Ogilvy
"Kalyan" wrote:
is there any way to change datasource dynamically
Example.
I will three Command Button, each button refer to three data source
Button A - Production
Button B - Development
Button C - QA
based on click, pivot table will change the data source, if i press refresh
i will populate corresponding data
thanks
|