In the Story Report Query Designer, a Query Advanced filter is the correct tool for creating a single filter that incorporates criteria from multiple tables. This type of filter is applied to the entire query's dataset after the tables have been joined. It provides an expression editor where you can build complex logical conditions (using AND/OR operators) that reference fields from any of the tables included in the query, thus satisfying the requirement to filter based on criteria from multiple sources in a single step.

A. Query Scope filter: This is not a standard or official term used for a filter type within the SAP SuccessFactors People Analytics Query Designer.

B. Table Simple filter: This filter is limited in scope to a single field within a single table and does not support complex logic or cross-table criteria.

D. Table Advanced filter: This filter, while allowing for complex expressions, is still restricted to the scope of a single table and cannot reference fields from other tables in the query.

1. SAP Help Portal - SAP SuccessFactors People Analytics: In the guide "Implementing and Managing Analytics in SAP SuccessFactors," the section on "Filtering Data in a Query" details the different filter types. It explains that filters can be applied at the query level or the table level. A query-level filter is necessary to access fields across all joined tables, and the "Advanced" option provides the calculation editor to build the multi-table expression. (Reference: SAP Help Portal, Implementing and Managing Analytics in SAP SuccessFactors, Section: Building a Query -> Filtering Data in a Query).

2. SAP Learning Hub - THR92 Courseware: The official THR92 course materials, "SAP SuccessFactors People Analytics: Reporting," explain the functionality of the Query Designer. Unit 4, "Creating Stories," demonstrates that to filter the combined result of a query, a filter must be applied at the query level. The lesson on advanced filtering explicitly shows how to use the calculation editor to reference columns from different objects (tables) in the query schema. (Reference: SAP Learning Hub, Course THR92, SAP SuccessFactors People Analytics: Reporting, Unit 4, Lesson: Advanced Filtering in Queries).