FlexNet Manager Suite
2020 R2
(On-Premises)
You can count rows in reports and create subtotals using the ALV
Count column.
The report results display in ALV grid lists. You can customize the order of the
display, the sorting, and the selection of the columns. In addition, you can save
display templates, form sums, and export data for further processing (for example,
into Microsoft Excel format). For more detailed information, refer to the SAP
documentation.
The report header shows the total number of rows of the report in brackets. The Logon
Evaluation and User Data Validation reports contain an ALV
Count column in the ALV grid to enable you to create subtotals of
report rows.
To count rows in reports:
-
Execute the report. (Refer to the relevant section in this User Guide for more
detailed information about the individual reports.)
Example: Click Reporting, then select
Logon Evaluation from the menu. Execute the report.
-
Sort the column that contains the data that you want to count (called column X
in this procedure) in descending order.
Example: Select the Cost Center column and
click the Sort in Descending Order button in the
Application toolbar.
-
For better visibility, position the ALV Count column and
column X next to each other: Select the ALV
Count column and drag it next to column X.
-
Select column X and the ALV Count
column.
Example: Hold down the Ctrl key and select
the Cost Center column and the ALV
Count column.
-
In the Application toolbar, click the Total button.
Scroll to the bottom of the list. A yellow row has been added at the bottom and
shows the total number of rows in the ALV grid.
-
Again, select column X and the ALV
Count column.
Example: Hold down the Ctrl key and select
the Cost Center column and the ALV
Count column.
-
In the Application toolbar, click the Subtotals button.
Underneath each cost center group, a yellow line displays the subtotal of rows
that make up the group.
FlexNet Manager Suite (On-Premises)
2020 R2