Thanks for the reply. In that link, the detail and summary are coming from the same data connection. Basically, the summary is obtained by doing a COUNT. In my scenario, i have a separate table (data connection) that holds the summarized information and now i have to link this to my detail table (another data connection).
You haven't said anything about volumes, so this solution might not work for you:
An initial way to try would be to set up your summary table using the technique from Option 2 - Stacked Bars, where the job_id would be on the Level of Detail Shelf. Then the job_id can be passed to the detail source in a Filter Action. Note that this only works when the user clicks on the *header*, not the individual bar segment
If that doesn't work, then you might look into doing more data prep so you have a merged data source that has the summary and detail available.