If data are sorted in the frontend using the header functionality, the behavior in case of NULL values is sometimes misleading.

In the below example, the data are sorted descending by Penetration, but at the beginning of the list you find the NULL values:

In order to solve the issue, the sorting has to be done with the "Actions" button functionality.

• Click on "Actions" --> "Data" --> "Sort"

• A pop up screen will appear
• In the "Sort" screen you are able to define, if Null values have to be shown at the beginning (first) or at the end (last) of the report