Excel for Data Analysis and Visualization

Working with the rows in a Pivot Table- field settings

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop