Reading field values selected by a Page variable

M

Mark Parent

I have a pivottable with row, column (District) and page (Region) variables.
There are 80 districts available when Region is set to ALL, but only a few
for each Region.

I need Basic code that can read the District values displayed to the user
depending on the Region selected. The District field is already set to
ascending sorting. The code:
Set fld =
AllDistrictsCalc.PivotTables("PivotTable5").VisibleFields("District1")
NumDistricts = fld.PivotItems.Count
always returns "80". The code:
For iItem = 1 To NumDistricts
flag = fld.PivotItems(iItem).Visible
Next iItem
tells me all values are visible.

Can anyone point me in the right direction? Am I simply using the wrong
Property?
 

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

VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Macro Help in Pivot 2
new user! Can anyone create this somewhat simple database? 3
I am low access user.Can someone create this somewhat simple datab 0
Excel Pivot Table - Get data in Pivot Field 0
Excel selective search for a combination of values - urgent 0
A simple printing pages depending on cell value 3
Dynamic code for the Read Page 0

Top