COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: kevinl1210 on 30 Jan 2020 05:18:22 AM

Title: Click on clustered column bars to filter details in list
Post by: kevinl1210 on 30 Jan 2020 05:18:22 AM
Hi, I am using cognos analytics 11.1.3.

I have a report that contains a visualization (clustered column) and a list. Each column bar in the visualization is a product category, the list will display the details of the categories.
My goal is:
When I click on the column bar of category A, then the list is filtered and will only display the details of A; when I click on B, then the list will only display the details of B; when I unclick the column bars, the list will display the details of all categories.

I have tried to define a drill through definition for the clustered column visualization, but it is not doing what I want instead of running a target report.

Can anyone please provide me some hints for this? ;D Thanks in advance.
Title: Re: Click on clustered column bars to filter details in list
Post by: kevinl1210 on 31 Jan 2020 04:52:30 AM
I finally found the solution for my problem.    ::)
What I needed is a active report, I then create a new connection between the clustered column and the list.
Specify the source control as the clustered column, specify the target control as the list, specify the behavior as filter, and it will work.