- [Instructor] Filtering is a very useful tool
to narrow report results
when the report has been run too broadly.
It allows us to drill down and see the more narrow results
that we define.
To demonstrate, we need some data.
We'll enter our list of sales orders report
using transaction code VA05.
Now, we'll execute this report
without any selection criteria defined.
We can now see that our report results
show 120 sales order entries.
Now let's filter.
First, we'll click our set filter icon.
Filtering is a two-step process.
First, we have to decide what we want to filter by.
Let's say we want to see only sales orders
that include a specific material.
First, we'll click material from the column set
and click the left arrow.
This moves us in to our filter criteria column.
The second step is to define our filter values.
We'll click the define values button.
This opens our determined values for filter criteria pop-up.
We'll enter our material number fg-mat-01,
and press execute.
We can now see that 14 sales orders
fit our new filter criteria.
When we look at our material column,
we see that all our sales orders contain
the material fg-mat-01.
Filtering is similar to narrowing
a report selection criteria,
but in this case,
it's done after we've already run the report.
Filtering is a really useful tool to drill down
within our report datasets.