Filter A Dimension in a Straight Table by clicking on total count in another table

[krishna_2644]

Hi Folks,

I have/made a pivot table with 2 dimensions : 1.Period 2.Metrics

with an expression : COUNT( DISTINCT{1} ID)

i have another Straight table with 7 dimensions  say 1.Id 2.HCP .. etc

My requirement : when i click on any counted value on the pivot table, the IDs should get filtered in the other straight table.

Any Help/Suggestions are highly appreciated.

Thanks

Krishna