Hi Folks,
I have/made a pivot table with 2 dimensions : 1.Period 2.Metrics
with an expression : COUNT( DISTINCT{1} ID)
![Capture1.PNG](/legacyfs/online/90437_Capture1.PNG)
i have another Straight table with 7 dimensions say 1.Id 2.HCP .. etc
![Capture2.PNG](/legacyfs/online/90438_Capture2.PNG)
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