I have previously write post Filter interactive report by clicking report cell that was working also in APEX 3.x.

Here is updated version how do same using dynamic action. Code is enhanced also to set search column.

Create dynamic action to page where you have interactive report:

  • Name: Filter report
  • Event: After Refresh
  • Selection Type: Region
  • Region: {select IR region}
  • Condition: -No Condition-
  • Action: Execute JavaScript code
  • Fire On Page Load: True
  • Code:
    var r=$(this.triggeringElement);
    r.find("table.apexir_WORKSHEET_DATA td").dblclick(function(){
     var l=$(this);
     $s("apexir_CURRENT_SEARCH_COLUMN",l.attr("headers")); // comment out this line if you like search from all columns
     $s("apexir_SEARCH",l.text());
     r.trigger("apexrefresh");
    });
    
  • Selection Type: None

Now run page and double click report cell to filter your report.

See working example.