Need to drill down from two different tables

Hi Guys,   I need to drill down a column which is available in another table, current column is opt for drilling is in another table.    Ex: Category name from category table is to drilled down t...