Concur - Find reports with just one specific exp type

[naqsa]

Hi All,
I'm trying to identify all expense reports that contain just 1 specific expense type. If I filter by the expense type i.e. airfare, it shows me all reports that have airfare and may have additional expenses as well. I need to identify reports that don't have any expense other than airfare. It can have multiple lines for airfare but cannot have any lines for other expense types. 
Thanks

[Michael75]

You need a report with three queries.
Q1 has column Document ID, and filter Expense Type = airfare
Q2 has column Document ID, and filter Expense Type <> airfare
Q3 has all the columns needed by your report, and two filters:
- Document ID in (Q1.Document ID)
- Document ID not in (Q2.Document ID)