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

Filter based on Running diff value

Started by texasw, 16 Dec 2015 04:56:08 PM

Previous topic - Next topic

texasw

I have a report in report studio where I have grouped by container number then added a data item to event type, then sorted by container number, event date and data item.
what I need to do is filter report where 2 is missing between 1 and 3, it is essentially a missing event. I can't work out how to do this? Please see attached data.

I also created a Running difference data item thinking I could find where OC is 5 and only show all data related to this based on BL or container number grouping...
see attached.
Also how do I filter group where there is only 1 row of data?