The following report was created in Report Studio using a relational package and shows revenue
by sales rep, city, and country.

What will the report show if the author creates a detail filter for Revenue>500,000 and applies the
filter AFTER auto aggregation?

A.
Only reps who generated total revenue greater than 500,000.

B.
Only cities that generated total revenue greater than 500,000.

C.
Only countries that generated total revenue greater than 500,000.

D.
Only reps who had individual sales transactions of greater than 500,000.

Explanation: