Members in a PageField
 

I want to create a customized report in Excel XP, in which I hide all
the filters (PageFields) in the Pivot table. I then want to use "my
own" Combo boxes to make the selection from. Is there a way to list
all the eg. Companies in PageField Company?

I have tried to use PivotItem, but a PageField doesn't seem to contain
any Pivotitems(?).

Thanks in advance,

Rickard

Members in a PageField
 

A PivotField has PivotItems.

Regards
BrianB



(Rickard) wrote in message . com...
I want to create a customized report in Excel XP, in which I hide all
the filters (PageFields) in the Pivot table. I then want to use "my
own" Combo boxes to make the selection from. Is there a way to list
all the eg. Companies in PageField Company?

I have tried to use PivotItem, but a PageField doesn't seem to contain
any Pivotitems(?).

Thanks in advance,

Rickard