Pivot Table "page field" use?

[SnumSnum]

I am trying to create a pivot table with the pivot table wizard and one of the questions on the wizard is about creating page fields (how many, create your own). I have tried 0, 1,2,3, and 4 and also tried to create my own. It just creates a filter looking box at the top of the pivot table. What technically is the page field for? Is it an overall filter? How do I assign something to it? All I can select is All or blank.

 

[RoryA]

Are you creating a pivot table from multiple consolidation ranges?

 

[SnumSnum]

Yes, I am practicing with 2 data ranges but will need to add 9.

 

[RoryA]

I suggest you read this: http://www.contextures.com/xlPivot08.html

IMO, such pivot tables are largely useless.

 

[SnumSnum]

How else do I combine that many ranges? Can I create tables on each tab and then combine them?