Hi,
I'm having trouble getting my PowerPivot Field List to appear correctly with my Pivot Table.
When clicking on the pivot table, a field list appears to the right with the header "PivotTable Field List". The layout is burdensome to use because all of their fields are grouped under Sigma (Sum) signs and you have to use a drop down to search for the table you're trying to locate.
When I click under the "PowerPivot" tab in the menu, the Field List option is grayed out - which leads me to think there's 2 kinds of Field Lists:
A PivotTable Field List and a PowerPivot Field List
Is there a way to bring back my PowerPivot Field List and in a user friendly format?
Thanks!
Acfbobcat
Excel 2010
I'm having trouble getting my PowerPivot Field List to appear correctly with my Pivot Table.
When clicking on the pivot table, a field list appears to the right with the header "PivotTable Field List". The layout is burdensome to use because all of their fields are grouped under Sigma (Sum) signs and you have to use a drop down to search for the table you're trying to locate.
When I click under the "PowerPivot" tab in the menu, the Field List option is grayed out - which leads me to think there's 2 kinds of Field Lists:
A PivotTable Field List and a PowerPivot Field List
Is there a way to bring back my PowerPivot Field List and in a user friendly format?
Thanks!
Acfbobcat
Excel 2010