dynamic deselect

[roshnirao]

How to deselect dynamic data?

for the set of data selected, I want to deselect records that are marked as 'HAPPY-PATH' and 'NOT IN MY INVENTORY' only for the latest date.

How to write an action for this?

selection <> max(CONTROL_MON) & '|'  "*HAPPY-PATH*"

or selection <> max(CONTROL_MON) & '|'  "*NOT IN MY INVENTORY*"

I have data like below. Here max(CONTROL_MON) is 01/12/2019. The below highlighted record should be excluded from the selection.

CONTROL_MON	KEY_LINK	CATEGORY	SUB_CATEGORY	CONCAT
01/12/2019	1	EXCEPTION	EXCEPTION	01/12/2019EXCEPTION
01/11/2019	1	EXCEPTION	EXCEPTION	01/11/2019EXCEPTION
01/10/2019	1	EXCEPTION	EXCEPTION	01/10/2019EXCEPTION
01/12/2019	2	HAPPY-PATH	EXCEPTION	01/12/2019HAPPY-PATH
01/11/2019	2	NOT IN MY INVENTORY	EXCEPTION	01/12/2019HAPPY-PATH
01/10/2019	2	HAPPY-PATH	EXCEPTION	01/10/2019HAPPY-PATH