Pivottable: 1 xlPageField but with many "Sub" pivottables

[johnb]

Hi All
I need to view data, eg, gender, age, ethnicity and several views on one
worksheet. Can all these views(seperate pivottables) have a common
xlPageField?

Each PT is grouped on Months on a Row and gender, age, ethnicity etc on
lefthand column.

Its bit like having a dropdown combo box who selection act as a filter for
many pivottables. Any suggestion as to how I crack this one??

TIA
johnb

 

[Debra Dalgleish]

There are a few sample files here that you could adapt to your worksheet:

http://www.contextures.com/excelfiles.html

Under PivotTables, look for
PT0016 - Change Page Fields With Cell Dropdown
PT0015 - Change Multiple Different Page Fields
PT0008 - Change Multiple Page Fields

 

[johnb]

Hi Debra,

Thank you for the missive. That link looks good.

johnb