Learn how to leverage filters to find specific information in the Data table.
First make sure that the Data table is in the ‘Entries’ view. You can then input one condition as ‘Account IS Increasing credits Revenue’ with an ‘AND’ clause, and another condition as ‘Account IS NOT increasing debits Cash’ 'OR' ‘Account IS NOT Increasing debits Accounts receivable (A/R)’, as shown below.
Note: The exact filter conditions and terms suggested above may not be identical in every dataset. Using any similar terms based on the dataset being used will present the desired outcome.