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