“Report Filter”

A “Report Filter” is used to see one or more items from that field.
A field that is in the “Report Filter” area can never be in another area.

If you insert a field in a “Report filter” area that is already used in another area, then that field is automatically removed from that area.
For each “Report Filter” field, a filter button is added on the right of the field name.

The field that is placed in the “Report Filter” area, is placed at the top in the “PivotTable”.
We have the field name on the left, and the filter on the right.
By default, the filter All, which indicates all the data from this field, is displayed in the “PivotTable”.
To filter the data, we click the downward pointing arrow.
This opens a list with all possible filter values.
These filter values are totally dependent on the data used in our table.
Click on one of the categories from the list when you want to filter and click the OK button.

If you want to filter on multiple data, eg Antwerp and Limburg, then click the check box for the text “Select multiple items.”

For each category in the list, you will see a box that you can select.

Check the boxes you wish to filter on and click OK.

If one or more filters applied, the downward pointing arrow next to the field changes to arrow and an icon of a filter.

If you wish to change the settings of a filter, click on the arrow next to the filter icon. This opens the list where we can make our changes.

Several “Report filters”

In the Report Filters area, we can place two or more fields.
Each of the “Report Filter” has its own filter button

I can not tell you wich fields you have to plac in what area, this depends on the results that you want to see.
But as you work more and more with “PivotTables”, this will be so obvious to get a thorough analysis of you data.

Sorting and / or filtering Row and Column fields

We can also “Sort and Filter” Row or Column Labels.
Click the downward pointing arrow next to the row or column label.

In the upper section we first make a choice between the various fields, which are placed in the Row Labels area, or Column Labels.
City, in this case.
To sort we have three choices, A to Z, Z to A, and “More sort options”.
In the “More sort options” we have an additional option,”Manual”, where we can click and drag the data fields to the position we desire.
Click OK when you’re done.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats