June 6, 2017

PivotTables:

Filtering the Data

Now that you have created a PivotTable with all this data and you want to focus on smaller fragments of it, you are able to filter this!

How to Filter Pivot Tables

Under ‘PivotTable Fields’ click and drag the field you want to filter in the ‘FILTERS’ area below. For this example, I have filtered ‘Client’.
Note: You will notice that in row 1 that the field Client appears.
In Row 1 where the client field appeared, click the dropdown – here you are able to select or deselect items to see certain clients, project or data.

Learn how easy it is to manage tasks, project plan, budget and more with ProWorkflow

Learn how easy it is to manage tasks, project plan, budget and more with ProWorkflow

Start your 14-day trial. No credit card. Unlimited users.