Change Pivottable layout through VBScript

[Guest]

Hi,

I have an html file that includes a vbscript for connecting to a .cub data
source and
adds pivot table fileds to the page. The script works fine and I can see
the pivot table there. The only problem is that I want the dimensions
(fliters) to be listed
vertically not horizontally.

In other words I would like to change the cube's layout. Could anybody tell
me how I can do that.

I would really appreciate any help,
Thanks.

 

[Guest]

Thanks for the reply. I tried what you suggested, but it
didn't work. The layout is still the same.