List members in Dimension (Pivot table field)

[Rickard]

I'm using Excel XP and Pivot tables as an OLAP front-end. I now want
to list all members in a specific Dimension (Pivot table field), and
finally add them to a Combo box. I think it's possible to do with DSO,
but is it possible to do it directly from the Pivot table?

Rickard

 

[keepitcool]

unless i'm confused..
drop de Dimension in the PageFields area and you should be ok..

keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Tom Ogilvy]

Private Sub CommandButton2_Click()
Dim pvtItem As PivotItem

For Each pvtItem In Worksheets("Pivot1") _
.PivotTables("PivotTable1").PivotFields("Header1") _
.PivotItems
UserForm1.ComboBox1.AddItem pvtItem.Value
Next

End Sub


Works with a standard pivot table. You would have to check it with a pivot
table fed by an OLAP cube as the pivot table depends on the Cube to do a lot
of the processing.