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

Tags:

Leave a Reply