2715521 - Using Calculated Columns Conditional Statements for Filtering records - Advanced Reporting

The report requires certain conditions for filtering report results that is not possible to be defined in the Filter Designer/Manage Filter screen.  How can we apply If/Then/Else logic to the report query filters?

For example:
If the Eligibility Indicator = No, then the employee should only have Base Salary as a Pay Component.  If other Pay Components exist, then include this employee record in the report.

If the Eligibility Indicator = Yes, then the employee should have another Pay Component listed other than Base Salary.  If the employee does not have any other pay components listed, then include the record in the report.

SAP SuccessFactors Workforce Analytics

conditional statements as filters, if then else statements, advanced reporting calculated columns, field checks, filtering report using conditional logic , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To