I assume you are using
Multiple Consolidation Ranges on the menu 2 screens before the one you've shown since I believe that is the only way to get the page selection screen.
When you do this, you are making a Pivot Table, but it is sort of a combination of the Pivot Table feature and the
The page fields serve as semi-arbitrary tags on the data ranges that were used. Be aware that you have to enter a label for each page field for each range of data. For 3 ranges of data with 2 fields, you will need to enter 6 values. These values can be combined in the result table to provide some of the grouping and filtering features that would normally be available for "free" with a normal Pivot Table.
An example of when this might be useful is if you have a workbook that has different worksheets for each month of data. Ideally, you would put all of these into one table and add a month column to the single table. If this is not an option, you can use this multi-range consolidate and a lot of typing to achieve the same result.
I will show the 3 month version of this instead of the 12 month because I am lazy.
Set up and data
Let's assume we have the following (completely made up and useless) data. It describes sales for a couple of salesmen split into tables that indicate the month the data was collected. Since the data contains different columns and people and has multiple months, I would really like to get it into a more suitable format for analysis. To that end, I will create one of these Pivot Tables out of it so that I can do some analysis. Let's also assume that the column headers are names of products (B,C,E,G).
I would like to do the analysis by
QTR. (If I was using a normal Pivot Table, this would be easy with a date and the
Group Field option.)
Configure that page field setup
In order to do the analysis within those groups, I need to define the page fields to accommodate it.
For each of the ranges selected, I have typed in in the relevant categorizing data. In this case, it's the
MONTH and the
QTR. I did this for each range and field. Here is the dialog with this options in place. Excel helps a little with the drop downs. This process is quite slow and manual. Image shows the selection for the 4th item in the list of ranges. I have already typed in values for the other 3 ranges.
Resulting Pivot Tables, and how it might be useful
The resulting Pivot Table is not much more useful than just doing
Data->Consolidate on the ranges. It contains summaries of the data by row and column. We can see though that the
Page Fields have shown up in the
Report Filter section. This is slightly useful, it allows me to filter to only get data for a given month or quarter.
Where they are really useful is when you are trying to replicate the Grouping features that you can get in a normal Pivot Table. This is done by moving the Page Fields out of the Filters section and down into the
Columns section. If you do that in the order of
Page1, then you will get a nice hierarchical grouping.
The final note (emphasized above) is that you can do all of this much more quickly and without manual typing with a normal Pivot Table if it is set up properly. If you are limited by the way that data is arranged, then this might be a useful way of dealing with it in some circumstances.