Thread: EXCEL 2010 PIVOT TABLES - selecting data fields

In earlier versions of Excel, to select data fields, a drop down menu was available where you could simply check/select all/unselect all your data field(s) of choice. In Excel 2010, the data field is the only field that does NOT have the menu drop down, and you instead have to select your data from the Pivot Table Field List.

Say a pivot table is provided with 50 data fields (in the outline of the Profit/Loss statement) and all I want to show is three of the data fields (revenue, gross margin, and GM %). I have had to first REMOVE VALUES, then go into the Pivot Table Field List to select the three data fields I wanted. After doing this I have to reformat the data fields as all the formatting was lost when I removed all the values. And then the data fields have to be renamed to get rid of the "Sum of" that is now in their labels.

Is there a simpler way to do this?