Read Excel Tips Such As How To Use Multiple Data Fields As A Column Field At BrightHub.com
Page content
Strategy: When you have more than one field in the Data area, you will find that a new button appears on the pivot table that is called Data, as shown in Fig. 917. You can drag the Data button from the Row field to the Column field.
Summary: Although the default view of the pivot report for multiple Data fields is unusual, you can easily correct it by moving the Data field to the Column area.
Commands Discussed: Data – PivotTable