• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Using Disparate Data Sources ... > The Anatomy of a Multiple Consolidat...

The Anatomy of a Multiple Consolidation Range Pivot Table

After closer analysis of your new pivot table, you will notice a few interesting things. First, your field list includes a field called Row, a field called Column, a field called Value, and a Field called Page1.

It is important to keep in mind that pivot tables using multiple consolidation ranges as their data source can only have three base fields: Row, Column, and Value. In addition to these base fields, you can create up to four page fields.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint