need to show Category wise sub-Category wise sales in another sheet when we select a sub-category in the filter

Hi,

I want to show a comparison between Sub-Category sales and all Sub-Categories in a category. i mean: when I click on Sub-category in the filter as shown below it has to  show that Sub-category value in one sheet and all the Sub-categories values to which category that particulate Sub-category( selected in Filter) belongs to in another sheet.

below is a example screen shot. i didn't achieved it. for understanding purpose  i showed.

please anyone get this solution as soon as possible for me.. it a major requirement form my client.