COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Karanag on 28 Sep 2015 02:57:46 AM

Title: Use one Query item multiple times in the same list based on filtering condition
Post by: Karanag on 28 Sep 2015 02:57:46 AM
Hi,
I need to create on list report which is having multiple query item in that, so i have a requiremnt that one query item needs to be use in multiple times.
Like if i have on field which is having different value based on filtering conditon  i need to take count of other query item in the same list report,likewise for next filter condition need to show the count of same query item in the same list. How can i go ahead with this.
Like for dept1 i need to take count of emp in one column , for dept 2 count of employee in same list with other column like wise
Could anyone please help me in this?