The link on the pivot table in a report returns an empty result.

1. Navigate to Reports > Create New.

2. Create a new report with a pivot table type, for example, use the source type: table and incident as table.

3. Add a filter for incident State is in progress AND Closed on last 9 months.

4. Generate the pivot table and click the link in the table.

   When you click on any link in that report, it goes to list view of the table, but it shows an empty result.

Use multilevel pivot instead of a pivot table .