Pivot table help needed

S

Sajith

HI,

I tried to the example given in this site...

http://www.contextures.com/xlPivot03.html


For Show/Hide Items codes -- Visible property is not found
to be working. Visible Property is working if the data
source is EXcel itself. If the data source is analysis
Manager, Visible property is always true...Is there any
work around. I have done the macro recording. That is
giving a long code which can not be implemented. also I
will not able to add a calculated member in the pivot
table because the olap datasource is analaysis amanager..

Thanks in advance for any help regarding this.

Thanks and regards.

Sajith Sudhi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table help needed 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot Table Help 1
Remove data from OLAP pivot table 0
Pivot Table Problem 1
Pivot Table with MS Access as DataSource 1
Excel Pivot Table, Property Fields 0
Pivot Table Help 0

Top