Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List members in Dimension (Pivot table field)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List members in Dimension (Pivot table field)
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 (Rickard) wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List members in Dimension (Pivot table field)
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. -- Regards, Tom Ogilvy "Rickard" wrote in message m... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
Excel 2007 - Calculated Dimension Members Greyed Out | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Pivot Table Field list | Excel Discussion (Misc queries) | |||
help! dimension members how to not be selected by default | Excel Discussion (Misc queries) |