Rockwell Automation FactoryTalk Report Expert User Guide - Manual (Page 93)

Understanding Parameter Sets Chapter 6
Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014 93
This filter: Filters by:
[User Defined
Summarization Fields 1-5] Names of the flex fields. The names can be changed by the
administrator in the Configuration Console.
To remove a filtering field and value from the parameter set, click
.
Use the Top N parameter to enable a parameter set to limit the data
of a report to the top (or bottom) N (number) of occurrences of a
field you specify.
When enabled, you must specify the field that you want to limit and
its desired maximum number of occurrences. The sorting will
determine what the top or bottom N occurrences are of the limiting
field.
When Top N is enabled, the top N rows of a dataset grouped only
by the top N field and sorted by the top N field called
using, will
determine the top N occurrences of the top N field. Top will give
the largest values of the top N field while bottom will give the
smallest values. N can be a number between 1 and 20.
The following example illustrates that the Top N are determined for
the entire dataset (without regard to the grouping fields):
Let’s say you wanted an Event Summary report. The parameter set
selected was by Work Cell, and the grouping was set to Event
Deleting a Filter
Using the TOP N Parameter