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 -- Visible property is not 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 from External Datasource of Excel Workbook 0
VBA Pivot Table: Determining item from one field based on anotherfield item 0
pivot table loosing decimals (vba) 1
How edit cell in Pivot Table 1
Multiple Tables and Multiple Pivot Tables Help 0
Pivot Table Filtering - Macro 3

Top