Required Not In Condition with in Same Index

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
Open Search 3.2

Describe the issue:

If Have One index having records with Properties Email and Event
We have different Events like Submitted, Delivered,Bounce etc.
I want to Get those record that available in Submitted only.
Means If any Email has to delivered or Bounce then it’s not shows in the result.
Example:
Email Event
Sunny@x.com Delivered
Sunny@x.com Submitted
pp@x.com Submitted
If these are the record available in the index then It return on pp@x.com because it has only Submitted Record.

Configuration:

Relevant Logs or Screenshots: