Blog on software engineering
Difference between PowerPivot Field List and the PivotTable Field List in Excel 2010

Difference between PowerPivot Field List and the PivotTable Field List in Excel 2010

When you are using PowerPivot in Excel 2010 there are two field lists:

 

PowerPivot Field List
Used for PowerPivot charts and tables
Click on a PowerPivot chart or tables then on the ribbon > PowerPivot tab > Field List

image

 

PivotTable Field List
Used for normal charts and pivot tables
Click on a chart then on the ribbon > PivotChart Tools > Analyze > Field List
Click on a pivot table then on the ribbon > PivotTable Tools > Options > Field List

image

image

 

 

Field Lists

image

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.