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