How to expand a single member

J

John

Im using VB 6 and OWC 10/pivot table to display an OLAP cube but i cant find out how to expand a single member
in the row axis

My row axis consists of Team and Team Members. What Im trying to do is to expand the view for the current team so that when the cube loads it show all the members of the current team

ie

Team
Team
Team
Fre
Jo
Pau
Team
Team

I know what the team currently is and have it stored in a string variable

Ive tried the followin

PivotTable1.ActiveView.FieldSets("Team Dimension").Fields(0).Expanded = Tru

But this expands all the teams

Can anyone give me an example peice of code which shows me how to expand a single dimension member

Thanks in advance
John
 

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

Formula error on created member 0
Expand field member 1
Ohh! Troubles in OWC10 and Javascript 0
Multiple resources for a Single task 1
How to get tasks from different projects into a single plan 1
How to monitor the Pivot Table data. 3
How to get memberproperty value programmatically 6
Descendant Count of CurrentMemeber with Multiple Selection 0

Top