Working with the rows in a Pivot Table- field settings

Please purchase the course before starting the lesson.

Once you have rows in a Pivot Table, you will notice that you have a variety of options available to you when you click on the field settings option

This lesson shows you how to work on the rows in a Pivot Table so that you can customise the name of the field, specify whether or not you want the subtotals and what they should be e.g. SUM, COUNT etc, specify the report layout in this screen, make the Pivot Table show all the items on all the rows to make it easier to use as another data source and insert blank lines into a Pivot Table.

To see the full course contents click here.

Back to: Intermediate Excel Course > Pivot Tables