When you add multiple fields to the row or column area, the outer fields automatically get subtotals. For example, in this pivot table, Region and Employee are the outer fields, and a Total row was added for each item. Sometimes these subtotals are useful, but in other pivot tables you might want to stop them [...]

In your pivot table, you might like the subtotals to appear at the top of the row field items. If the pivot table is in outline (Report) layout, you can format the field to control where its subtotals appear: Double-click the field button to open the PivotTable Field dialog box. Click the Layout button. Select [...]

In your source data, you might record the amount of time that employees have spent working on projects. For example, Jim worked on Project A for 8 hours Monday, 8 hours Tuesday, 6 hours Wednesday and 3 hours Thursday, for a total of 25 hours. In the pivot table, you want the total time per [...]