If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Multi column filter

Started by Rvp246, 19 Jan 2021 06:56:15 PM

Previous topic - Next topic

Rvp246

Group ID          Status         Product
AA12                 1                B
AA12                 2                A
BB23                 1                A
BB23                 1                A
CC34                 2                B
CC34                 2                B

My data looks like the above and what I am trying to do is filter it such that I only get Group IDs where the status is the same for both products. In other words an output of rows with a status of 2

CC34       2                B
CC34       2                B

The main issue I'm having is trying make a filter that will remove the group IDs like the first two rows

BigChris

I haven't tried it, but would something like

count(distinct ([Group ID] || [Status])) > 1

work for you?