create a dashboard on reports where I can select a group and a role and then the output will show two reports showing members of that group that have the role and one report that shows members that do not have that role.

[Nadeesh]

Hi Guys,

I want to create a dashboard on reports where I can select a group and a role and then the output will show two reports showing members of that group that have the role and one report that shows members that do not have that role.

I have achieved half part which is if I select a group and a role then the output will come from those who are holding a role in that group.

Please help me to reverse the report to get who don't have the role

[Tsura Andreeva]

My understandig was that the Assignment Group gave the members the roles, so if that group does not have the role you select all group members will show up in your report. 

[Nadeesh]

I tried but interactive filter applies for all the report.

[Tsura Andreeva]

I guess one solution could be to chunk the report in to two or more for each data point you are trying to flush out and the data points you dont want the interective filter to work on, just exclude it. Also I am not sure what interactive filter you are using but I wonder if cascading might not be the way to go. 

[Nadeesh]

Yes, I'm using Cascading Filter for that. Please suggest steps so I can achieve this problem statement.