Excel for Data Analysis and Visualization

Working with the rows in a Pivot Table- dropdown

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 in the dropdown arrow.

This lesson covers how you can search for parts of a name, or search in the label or value filters, using the the Top 10 Option in the Value Filter to make sure that Pivot Table doesn’t overwrite another pivot table, sorting rows based on the words in the field itself (generally alphabetically), or one of the value fields.

To see the full course contents click here.

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