SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 112
Count Query Result: With Grouping
Manager Type Count
Miller Full-time 38
Miller Part-time 3
Jackson Full-time 10
Jackson Part-time 1
Sullivan Full-time 16
Note that the order in which the fields appear in the Selected Fields list is important. The
results are first grouped by the first field, then by the second field, and so on.
If you had first selected Type and then Manager from the Employees table, the order of the
columns above would be reversed, grouping the result first by employment type, then by
manager, as in the table below:
Count Query Result: With Grouping
Type Manager Count
Full-time Miller 38
Full-time Jackson 10
Full-time Sullivan 16
Part-time Miller 3
Part-time Jackson 1
For the description, sample business questions, and process flow of working
with the Count template, see Count (Relational) [Page
97].
